Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish to get some code that will select and delete a group of sheets - those
that are between two other sheets "Frontsheet" and "Endsheet". I have tried to record this but what I get is simply Application.Goto Reference:="Frontsheet!R[1]C[1]" ActiveSheet.Next.Select Sheets(Array( "Sheetname1","Sheetname2"... "SheetnameZ").Select etc where "Sheetname1" is the sheet following "Frontsheet" and "SheetnameZ" is that before "Endsheet" The sheet names of the sheets between "Frontsheet" and "Endsheet" will not always be the same and the number of sheet will also vary. I am quite sure there is code out there to do this, but I'm slightly stumped. can anyone give some guidance? TIA Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Group Boxes - selecting more than one item | Excel Discussion (Misc queries) | |||
Selecting a group of sheet tabs | Excel Programming | |||
optimization-selecting a group with constraints | Excel Programming |