Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Function that returns the total number of cells in a range i

  1. #11
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your help again Nate!

    Do you have an example of a workbook_open and ontime procedure combination? Sorry, I am new at this stuff.

    Thanks,

    Jim

  2. #12
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I figured it out. I think that Worksheet_SelectionChange works the best.

    Thanks for all you help again,

    Jim

  3. #13
    Board Regular
    Join Date
    Nov 2010
    Location
    Wichita, KS
    Posts
    264
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Function that returns the total number of cells in a range i

    Quote Originally Posted by Jack in the UK View Post
    Hi

    I answered this heavly on the old boad with VBA to do just this:

    A friend Ivan F Moala edited it to colour of text .. have a look post answet by me and then Ivan, will be in first archive, the original code was by a great friend in Western Australia Dave Hawley http://www.ozgrid.com under vba section.

    Credit to he guys who did the real work, have a look at both, ill see if i can find the code as well



    _________________
    Good Luck
    HTH

    Rdgs
    ==========
    Jack in the UK

    [ This Message was edited by: Jack in the UK on 2002-02-24 14:27 ]
    I can not find the archives. Can you post a link to it? I could use help on this.
    Thank you in advance for any given,
    I work with Windows 7 Enterprise and Excel 2010

    So I can learn instead of just getting help and having you guys do all my work, can you not just help me but if you have time,
    explain why what I was doing was wrong and why the "fix" works? I really want to learn this language so I can do this myself too.
    Thank you so VERY much. I LOVE this forum.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •