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

--

Vasant



"Hawk" wrote in message
...
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.

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
...
index of the activesheet<<

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

--

Vasant



"Hawk" wrote in message
...
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.

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
...
index of the activesheet<<

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

--

Vasant



"Hawk" wrote in
message
...
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.




.