Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create named worksheet based on existing numeration
Greetings all.
Hope your respective weekends were enjoyable. I have recorded, and modified a macro that creates a worksheet within an existing workbook. For now, I've just set the name of the worksheet to be "A." I would like to now have this new worksheet named within the existing framework of the workbook. I.e., for this type of worksheet, we typically name them by a ordinal number-- 1 through N. In one workbook we may only be up to 5, and another could easily be upwards of 70, or more. Presently, the code for my worksheet name is: Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = "A" What would I use to make the name of the worksheet the next number inline for the respective worksheet? I appreciate your responses. Best. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create new records from existing ones based on 'rule'? | Excel Worksheet Functions | |||
Create named ranges in Column on worksheet | Excel Programming | |||
Macro to create a new worksheet that is a copy of an existing one? | Excel Programming | |||
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template. | Excel Programming | |||
Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) |