How do you return the number of a sheet in the sheets collection. I can
return the total number of sheets as in:

Sheets.Count

But I want the Sheet number.

Please help. Thanks

Hi,

You have multiple responses at your previous post.

---
Regards,
Norman



"Sheets number position"
wrote in message ...
How do you return the number of a sheet in the sheets collection. I can
return the total number of sheets as in:

Sheets.Count

But I want the Sheet number.

Please help. Thanks

Use the Index property of a worksheet to get its position. E.g.,

Debug.Print Worksheets("Sheet3").Index


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Sheets number position"
wrote in message
...
How do you return the number of a sheet in the sheets
collection. I can
return the total number of sheets as in:

Sheets.Count

But I want the Sheet number.

Please help. Thanks