Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Count sheets between sheets (2002)

    Is there a formula to count the number of sheets between two sheets or must I use VBA? e.g., Sheet named: begin has several (and variable number) of sheets between it and sheet named: end...I need to know how many are between "begin" and "end"

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Count sheets between sheets (2002)

    Kevin

    By far the easiest and a method that has worked well for me in the past is this:

    In the sheet called Begin place this in Cell A2

    =Count(Start:End!A1)-2

    You will have to have a value in each Sheets A1 (maybe a header)


    Enjoy
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count sheets between sheets (2002)

    Or perhaps

    =COUNTA(Start:End!A1)-2

    COUNT counts only numeric values, COUNTA counts the number of non-blank cells.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Count sheets between sheets (2002)

    Yep, a good alternative
    Jerry

Posting Permissions

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