| 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 | |||
Hybrid Mode
