Search:

Type: Posts; User: MartinM; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    18
    Views
    868

    Hi Bhushan I have created a very simple...

    Hi Bhushan

    I have created a very simple example which you can adapt to your specific needs. Note: it is created in Excel 2003.

    It has a set of existing Prices, in yellow in column C. When you...
  2. Replies
    18
    Views
    868

    I hunted high and low to find a simple solution...

    I hunted high and low to find a simple solution to this and concluded that the technique which RG suggests is the least difficult. My variation is as below . . .

    I use a macro to import the data...
  3. The frequency of interest calculations will alter...

    The frequency of interest calculations will alter the repayments a little - daily, twice daily, weekly . . .

    Or maybe there's a simpler explanation - the lender is rounding to the nearest $2.50.
    ...
  4. Replies
    12
    Views
    265

    Hi Fred, I asked about Recalculation because I...

    Hi Fred,

    I asked about Recalculation because I discovered, to my cost, that a number of actions seemingly unconnected to an open Workbook can cause many cells to display #REF! values. Opening a...
  5. Replies
    12
    Views
    265

    What happens if the Workbook is recalculated when...

    What happens if the Workbook is recalculated when it is showing all those #REF! values ?
  6. Replies
    13
    Views
    775

    I don't know an easy way to do that, but here is...

    I don't know an easy way to do that, but here is the hard way, plus some ideas !

    http://office.microsoft.com/en-gb/excel-help/find-external-references-links-in-a-workbook-HP010205611.aspx
  7. You have to dynamically name the indvidual Excel...

    You have to dynamically name the indvidual Excel tabs as Workbooks are opened/closed, using the ActiveWorkbook.Windows(n).Caption property.

    I've demonstrated to myself that it can be done manually...
  8. Maudibe, As I observed above, using the...

    Maudibe,

    As I observed above, using the ActiveWorkbook.Windows(1).Caption property is fine until you open another Excel Workbook.

    Try it, and you will see the issue - the first Workbook to be...
  9. OK, next curiosity. Using my own Workbook with...

    OK, next curiosity.

    Using my own Workbook with Application.Caption = " " the leading dash eventually disappears from the Taskbar caption without any action on my part - but it remains at the top...
  10. Well, you can get rid of the leading dash using...

    Well, you can get rid of the leading dash using the code . . .


    ActiveWorkbook.Windows(1).Caption = " "

    . . . but then, if you open another Workbook, things go sadly wrong.

    I expect there's...
  11. You can do this, but only using VBA: ...

    You can do this, but only using VBA:


    Application.Caption = ActiveWorkbook.FullName

    You have to run this line every time you open Excel, so you could, for instance, put it into an Auto_Open()...
  12. Maudibe, Your psychic powers are on turbo this...

    Maudibe,

    Your psychic powers are on turbo this evening - I was going to write just what you have written . . . taking out the line which calls up the message box is ALMOST the same as hitting...
  13. It only substitutes when you press Enter directly...

    It only substitutes when you press Enter directly after typing 2014.

    I can turn this on and off consistently with the setting mentioned above ON THIS PC but, curiously on another PC (which uses...
  14. Got it, thanks to hints from responders - thank...

    Got it, thanks to hints from responders - thank you both.

    Tools . . . AutoCorrect Options . . . AutoText tab . . . uncheck Show AutoComplete suggestions

    Job done :rolleyes:

    Phew, that's been...
  15. How to stop Word converting year (2014) to whole date format?

    When I type 2014 then hit [Return], Word 2003 turns it into 2014-11-02.

    I have tried, and failed to find the setting which controls this functionality.

    Help, please.
  16. Replies
    5
    Views
    260

    Yes, you can. Instead of using the...

    Yes, you can.

    Instead of using the "conditioned cell colour", you will find it far easier (to write and to debug) the VBA you need if you set the tab colour using the same test that the...
  17. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    1,270

    Thanks for the prompt replies. Refresh changed...

    Thanks for the prompt replies.

    Refresh changed the icon size but not the spacing - it needed a reboot to do that.

    Cheers.
  18. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    1,270

    Icon spacing

    XP SP3

    I am trying to get my desktop icons a little closer together.

    I can make them larger or smaller (Desktop, Properties, Appearance, Advanced . . . then Icon), but changing the Icon spacing...
  19. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    718

    Ho ho Alexandra ! I hope you don't mind a...

    Ho ho Alexandra !

    I hope you don't mind a serious answer to your lovely humour ?

    There's a balance in everything.

    You could spend months writing perfect code - logical examination of every...
  20. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    718

    It is difficult to answer your specific question...

    It is difficult to answer your specific question with any precision because there are so many possible circumstances !

    Code which is written in clearly logical sections, each performing a defined...
  21. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    718

    I presume you have tried single-stepping through...

    I presume you have tried single-stepping through the code ?

    This can be a pain when there are long loops, but its one of many techniques to work out what is happening as the code executes.
  22. Replies
    8
    Views
    269

    In the cell format dialog select Left (Indent)...

    In the cell format dialog select Left (Indent) and in the Indent: box choose how far from the left you want the characters to be.
  23. Replies
    8
    Views
    269

    Can't you simply left-align the cells ?

    Can't you simply left-align the cells ?
  24. Replies
    3
    Views
    147

    Perfect, thanks. I find the explanations for...

    Perfect, thanks.

    I find the explanations for the number formatting quite hard to follow, but the examples mostly clear it up.
  25. Replies
    3
    Views
    147

    OK, answered my own question ! I needed...

    OK, answered my own question !

    I needed "###,#".

    So my next question is . . . where is there a comprehensive list of the possibilities for the FORMAT statement - getting the answer above took...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4