sheets count

[Guest]

how do I return a value for the sheets number position? I can return the name:
Sheets.Name

But I want the value 34 if it were the 34th sheet out of 50 sheets. How do
I find this?

Please advise.
Thank you

 

[Norman Jones]

Hi,

The sheets index property returns its position in the sheets collection.

 

[Bob Phillips]

Sheets(sheet_name).Index

 

[Rowan]

If you want to return the postion of the sheet then:
activesheet.index
or
sheets("MySheet").index

If you want to refer to a sheet by its postion then
sheets(34).select 'etc

hope this helps
Rowan