Sheet count

[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.

 

[Vasant Nanavati]

index of the activesheet<<

Just a wild guess, but have you tried ActiveSheet.Index? <g>

 

[Tom Ogilvy]

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

 

[Hawk]

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


.