Search:

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

Page 1 of 11 1 2 3 4

Search: Search took 0.02 seconds.

  1. Hi Zeddy What can I say ... you are a real...

    Hi Zeddy

    What can I say ... you are a real genius! I am so grateful that you responded and did it so promptly!

    I only wish I could return the favour!

    Eternally grateful!

    useful :) :)
  2. Excel 2010 - date field leading space and serial value problems

    Due to a bug in Crystal Reports, date fields export into Excel with a leading space in the cell.

    As on this occasion VBA is not any option, I attempted to remove the leading space with a formula...
  3. Replies
    19
    Views
    531

    Thank you all. I have managed to work it all out...

    Thank you all. I have managed to work it all out (and learned a lot in the process) so all of the issues are now resolved.

    useful :)
  4. Replies
    19
    Views
    531

    I forgot to add that when I replace the number 1...

    I forgot to add that when I replace the number 1 with a tick, the colours disappear and as I can't find where they are, I am unable to restore them.

    I hope someone can assist.

    Thank you in...
  5. Replies
    19
    Views
    531

    I have managed to achieve two of the above three...

    I have managed to achieve two of the above three challenges, but I am unable to change the number 1 to a tick in the code, which for convenience, is listed below:


    Option Explicit

    Private Sub...
  6. Replies
    19
    Views
    531

    Hi All As you can clearly see, I'm just an...

    Hi All

    As you can clearly see, I'm just an keen amateur ...

    zeddy interpreted it all correctly, in spite of me. Clearly it makes no sense to be able to select more than one column in any one...
  7. Replies
    19
    Views
    531

    I seem to have got excited a little too soon ......

    I seem to have got excited a little too soon ... the code worked like a charm at the beginning, but when I added worksheet protection, it failed and also, it adds a 1 to every cell I click on, not...
  8. Replies
    19
    Views
    531

    Thank you all. You are wonderful! My issue is...

    Thank you all. You are wonderful!

    My issue is resolved and I am very grateful that the knowledgeable responses were so prompt!

    Long may you continue to give sound advice!

    useful :)
  9. Replies
    19
    Views
    531

    Sorry, my shorthand is obviously too cryptic. ...

    Sorry, my shorthand is obviously too cryptic.

    What I mean is, could you please add to the code, such that in addition to changing colour when clicked, the cell also now has a number 1 in it.
    ...
  10. Replies
    19
    Views
    531

    Hi Amazing Geek! You are a gem (as always)....

    Hi Amazing Geek!

    You are a gem (as always). Your code worked an absolute treat!

    The one thing I forgot in my previous post, was to also populate the clicked cell with 1 apart from the colour.
    ...
  11. Replies
    19
    Views
    531

    change cell color by clicking in Excel 2010

    I would like to change the colour of a cell by single-clicking on it, the colour to be determined by the column that the cell is in.

    In other words, when single-clicked, any cell in column 2...
  12. Replies
    6
    Views
    820

    [SOLVED] Thank you for the explanation Charles. Regards...

    Thank you for the explanation Charles.

    Regards
    useful :)
  13. Replies
    6
    Views
    820

    [SOLVED] Thank you folks! I did not realise that Word...

    Thank you folks!

    I did not realise that Word would 'remember' a deleted second page in a template. Very clever.

    Regards
    useful :)
  14. Replies
    6
    Views
    820

    [SOLVED] Word 2010 macro for page numbering

    I'm embarrassed to ask something so simple.

    I have just set up a letterhead template with a macro that inserts a second page and I would like to add plain page numbers centred in the footer in...
  15. Replies
    12
    Views
    1,814

    Thank you again Andrew. Regards useful :)

    Thank you again Andrew.

    Regards
    useful :)
  16. Replies
    12
    Views
    1,814

    Hi Andrew I forgot to ask you, could you...

    Hi Andrew

    I forgot to ask you, could you please tell me where I can find a list of the icons, one of which, 526, you inserted into the code.

    Thank you.

    Regards
    useful
  17. Replies
    12
    Views
    1,814

    Hi Andrew I have tested it and it works fine!...

    Hi Andrew

    I have tested it and it works fine!

    Thank you again.

    Regards
    useful
  18. Replies
    12
    Views
    1,814

    Thank you Andrew. I will try this code in the...

    Thank you Andrew.

    I will try this code in the morning, although I don't pretend to understand what you mean by 'recreate the macro so it is less dependent on cursor location'.

    Regards
    useful
  19. Replies
    12
    Views
    1,814

    Thank you for the explanation Andrew - so that's...

    Thank you for the explanation Andrew - so that's why the macro is not on the Add-ins tab!

    Unfortunately for me, I can't really write VBA code, I just recorded those macros, so as a result I don't...
  20. Replies
    12
    Views
    1,814

    Hi RetiredGeek, thank you for the follow-up. ...

    Hi RetiredGeek, thank you for the follow-up.

    I forgot to elaborate that I created this template years ago and since converted to Word 2010 and expected to see the new macro I created on the...
  21. Replies
    12
    Views
    1,814

    Thanks for your response RetiredGeek, glad you...

    Thanks for your response RetiredGeek, glad you are still providing your valuable assistance!

    This macro is a Sub, just like the other two macros that do appear on the Add-ins tab.

    Regards...
  22. Replies
    12
    Views
    1,814

    Word 2010 macro not showing on Add-ins tab

    This is probably a silly question, but I can't see why one of the three macros in a template does not display as a Toolbar Command on the Add-ins tab along with the other two.

    I would be very...
  23. Thanks for the suggestion Joe. This is one of...

    Thanks for the suggestion Joe.

    This is one of the first things I tried, but it made no difference. Clearly Outlook is enumerating the sub-folders, that's what I called 'indexing'. How can I...
  24. MS-Outlook 2010 delayed response - no solution yet

    I posted a 'plea for help' for this problem a few years ago, but no one has come up with a solution.

    Having done extensive troubleshooting, I can now precisely express the problem.

    Whenever I...
  25. Outlook 2010 - change column headings in Sent Items subfolders

    I have a great many subfolders under Sent Items and I would like to change the column headings in each subfolder without having to do it one subfolder at a time.

    Currently, I have a button I...
Results 1 to 25 of 267
Page 1 of 11 1 2 3 4