Sheet count

  • Thread starter Thread starter Hawk
  • Start date Start date
H

Hawk

How do I find the Index of the activesheet in a workbook?

For example...if the third worksheet in the worksheets
collection is active, I want a function that will return 3.
 
index of the activesheet<<

Just a wild guess, but have you tried ActiveSheet.Index? <g>
 
Note that ActiveSheet.Index returns an index into the sheets collection, not
the worksheets collection. If you have nothing but worksheets, then they
will be the same, but if not, they won't
 
Thanks...
-----Original Message-----
Note that ActiveSheet.Index returns an index into the sheets collection, not
the worksheets collection. If you have nothing but worksheets, then they
will be the same, but if not, they won't

--
Regards,
Tom Ogilyv

"Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message


.
Click to expand...
 
Back
Top