Shet Number Position

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" <[email protected]>
wrote in message news:[email protected]...
> 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"
<[email protected]> wrote in message
news:[email protected]...
> 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