Sheet count

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

Vasant Nanavati

index of the activesheet<<

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

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
 
H

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


.
Click to expand...
 
Top