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