| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet number
Hi,
Really simple question. I know that one can select a sheet by using "sheets(i)" where "i" is the relative number of the sheet in the workbook. But how does one do the reverse - get the sheet number of the active sheet? I tried "help" but could not find an answer. - eugene |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sheet number
Hi Eugene,
Try : Dim i As Long i = ActiveSheet.Index --- Regards, Norman "eugene" wrote in message ... Hi, Really simple question. I know that one can select a sheet by using "sheets(i)" where "i" is the relative number of the sheet in the workbook. But how does one do the reverse - get the sheet number of the active sheet? I tried "help" but could not find an answer. - eugene |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sheet number
perfect
thanks -- eugene "Norman Jones" wrote: Hi Eugene, Try : Dim i As Long i = ActiveSheet.Index --- Regards, Norman "eugene" wrote in message ... Hi, Really simple question. I know that one can select a sheet by using "sheets(i)" where "i" is the relative number of the sheet in the workbook. But how does one do the reverse - get the sheet number of the active sheet? I tried "help" but could not find an answer. - eugene |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| find an exact number in a different sheet and use the cell containing the number to output information | Excel Programming | |||
| 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 | |||
Linear Mode
