Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet number
Try this..
shCount = ThisWorkbook.Sheets.Count will give u the count of sheet numbers in your workbook. Kishore |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet number
ActiveSheet.Index
"aou" wrote in message oups.com... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet number
Thanks, every bodys
Thira |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
How can I refer to sheet number not sheet (name)? | Excel Worksheet Functions | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions |