Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    163

    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...
  2. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    644

    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.
  3. Thread: Icon spacing

    by MartinM
    Replies
    7
    Views
    644

    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...
  4. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    471

    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...
  5. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    471

    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...
  6. Thread: Debugging code

    by MartinM
    Replies
    16
    Views
    471

    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.
  7. Replies
    8
    Views
    216

    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.
  8. Replies
    8
    Views
    216

    Can't you simply left-align the cells ?

    Can't you simply left-align the cells ?
  9. Replies
    3
    Views
    114

    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.
  10. Replies
    3
    Views
    114

    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...
  11. Replies
    3
    Views
    114

    Formatting numbers with VBA

    I am trying to use a VBA FORMAT statement to display numbers with no decimal places and the comma separator.

    "00" gives me the correct display but without the commas

    "000,0" gives me the commas...
  12. Good news, thanks for posting back. Dontcha like...

    Good news, thanks for posting back.
    Dontcha like software that simply works !
  13. Replies
    10
    Views
    357

    Dear Howard, I have reviewed the many posts...

    Dear Howard,

    I have reviewed the many posts you have made concerning Excel on this and other forums and I conclude that you have a complex array of spreadsheets - linked by and containing VB...
  14. You use Companion Link - not free but very good.

    You use Companion Link - not free but very good.
  15. Replies
    4
    Views
    220

    Type outlook calendar change temperature to...

    Type

    outlook calendar change temperature to celsius

    into Google and look at the first hit
  16. Replies
    10
    Views
    357

    You will probably get your answer here: ...

    You will probably get your answer here:

    http://www.mrexcel.com/forum/excel-questions/800934-list-files-folder-sub-folder.html
  17. After some research I opted for Companion Link....

    After some research I opted for Companion Link.
    It works beautifully and the support is also very good - I had a longstanding Outlook issue which they successfully helped me to resolve.
  18. Replies
    5
    Views
    300

    http://www.companionlink.com/ - as recommended on...

    http://www.companionlink.com/ - as recommended on this forum recently - works brilliantly for me.

    And their support (by email) is prompt and effective.
  19. Replies
    1
    Views
    205

    OK, so I've been hunting round the Internet and...

    OK, so I've been hunting round the Internet and stumbled on the advice to press CTRL 6. This showed a fuller set of folders in the LH pane, which lists BOTH address books - Addresses and Contacts.
    ...
  20. Thanks Steve, but it's the change in relative...

    Thanks Steve, but it's the change in relative position which I am guarding against.

    Your first method does that for me.
  21. Perfect ! Thank you Steve, and for the...

    Perfect !

    Thank you Steve, and for the alternative ideas which I'll think about.
  22. VBA: changing a formula when columns are inserted / deleted

    I know I should be able to work this out, but I'm tired after a day of dancing and cycling !

    Anyway, on to the facts.

    I have a complex VBA routine which uses named ranges to ensure that if...
  23. Replies
    5
    Views
    447

    Does your PC have the correct time zone selected...

    Does your PC have the correct time zone selected in Regional Options settings ? Sounds as if you might be 2 hours out.
  24. Let's assume that the date you are starting from...

    Let's assume that the date you are starting from is in cell A1.

    If you are happy to ignore the effects of leap years then you can use the simple formula =A1-365

    If you need to be exact, you can...
  25. Replies
    1
    Views
    205

    Invisible contacts !

    Outlook 2003

    Sometime ago I "lost" my contacts. When I tried to create a new list Outlook said that Contacts already existed, so I named the new list Addresses, imported the contents from a backup...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4