Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I add sheet2, sheet3, and sheet4 to the current workbook.
Then I delete these new sheets. If I execute the following code: ---------------------- Dim a As Integer For a = 1 To 10 Sheets.Add Next a ---------------------- The sheets don't start at Sheet2, like I thought they would. Does someone have the code handy to "wipe out" the remberance of sheets that existed but are now deleted. Thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbering Worksheets | Excel Worksheet Functions | |||
Page numbering - grouped worksheets | Excel Discussion (Misc queries) | |||
Numbering Worksheets | Excel Discussion (Misc queries) | |||
Copying and numbering worksheets | Excel Discussion (Misc queries) | |||
Loop thru files in DIR, delete worksheets & reset worksheet Name property?? | Excel Programming |