| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect current active sheet number
ActiveSheet.Index will give you the sheet's number, regardless of its name
But if you're looking for something like "Sheet1" then you'd be better off withActiveSheet.Name Mike Chen wrote: Hi guys, When prohramming, I want to know the sheet number, how could I get it? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add todays date (static) to the current active cell using m | Excel Discussion (Misc queries) | |||
| Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
| Identify current active cell | Excel Worksheet Functions | |||
| Return number of current sheet | Excel Worksheet Functions | |||
| Detect when Active Cell Changes | Excel Programming | |||
Threaded Mode
