sheet number

[Guest]

Hi,

Really simple question.
I know that one can select a sheet by using "sheets(i)" where "i" is the
relative number of the sheet in the workbook.
But how does one do the reverse - get the sheet number of the active sheet?
I tried "help" but could not find an answer.

-
eugene

 

[Norman Jones]

Hi Eugene,

Try :

Dim i As Long

i = ActiveSheet.Index

 

[Guest]

perfect
thanks

--
eugene

Hi Eugene,

Try :

Dim i As Long

i = ActiveSheet.Index