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.