How to detect current active sheet number
 

Hi guys

When prohramming, I want to know the sheet number, how could I get it

Thanks

Mike

How to detect current active sheet number
 

ActiveSheet.Index will give you the sheet's number, regardless of its name

But if you're looking for something like "Sheet1" then you'd be better
off withActiveSheet.Name

Mike Chen wrote:
Hi guys,

When prohramming, I want to know the sheet number, how could I get it?

Thanks,

Mike

How to detect current active sheet number
 

Hi Mike,

depends what you mean by sheet number:

Dim j as long
for j=1 to Worksheets.count
msgbox "sheet number " & j & " is named " & worksheets(j).name
next j

this shows you the sequence number in the worksheets collection: is that
what you are looking for?


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Mike Chen" wrote in message
...
Hi guys,

When prohramming, I want to know the sheet number, how could I get it?

Thanks,

Mike

How to detect current active sheet number
 

Hi Steve

Thanks, It is just what I want!