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