View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron McCormick[_6_] Ron McCormick[_6_] is offline
external usenet poster
 
Posts: 6
Default Selecting a group of worksheets to delete

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