Sheet number

I can use Worksheets(2) to goto the second sheet on workbook, I can use
Worksheets.Count to goto the last sheet on workbook.
How can I get the Number of ActiveSheet(not sheetname, codename)?

Thira

Try this..

shCount = ThisWorkbook.Sheets.Count

will give u the count of sheet numbers in your workbook.

Kishore

ActiveSheet.Index



"aou" <[email protected]> wrote in message
news:[email protected]...
>I can use Worksheets(2) to goto the second sheet on workbook, I can use
> Worksheets.Count to goto the last sheet on workbook.
> How can I get the Number of ActiveSheet(not sheetname, codename)?
>
> Thira
>

Thanks, every bodys

Thira