Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determening sheet number
after command: Sheets.Add
is there a simple way of determining the number of the sheet just added? -as always, thanks in advance mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
determening sheet number
when you add a sheet it's autom. activated.. the "number" is given by the Index property Activesheet.Index -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam mark kubicki wrote : after command: Sheets.Add is there a simple way of determining the number of the sheet just added? -as always, thanks in advance mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
determening sheet number
You could always do
Woksheets.Add.Name ="mySheet" and you have its name -- HTH Bob Phillips "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 |
#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 |
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 |