sheet number
 

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

sheet number
 

Hi Eugene,

Try :

Dim i As Long

i = ActiveSheet.Index


---
Regards,
Norman



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

sheet number
 

perfect
thanks

--
eugene


"Norman Jones" wrote:

Hi Eugene,

Try :

Dim i As Long

i = ActiveSheet.Index


---
Regards,
Norman



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