| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
determening sheet number
Hi Mark,
You can also specify where you add the sheet so you already know the position. And I have a hinkering that this delves deeper than just knowing the Index of the sheet. Am I right? Anyway, examples ... Add a sheet as the first sheet: Sheets.Add befo=Sheets(1) Add a sheet as the last sheet: Sheets.Add after:=Sheets(Sheets.Count) HTH -- Regards, Zack Barresse, aka firefytr "mark kubicki" wrote in message ... after command: Sheets.Add is there a simple way of determining the number of the sheet just added? -as always, thanks in advance mark |
| 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 | |||
![zackb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
