View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
diba diba is offline
external usenet poster
 
Posts: 4
Default Deleting rows from mutliple sheets

Hello--could someone please tell me a more effecient way to loop
through each sheet (all are named) & delete the first 5 rows instead
of the following:

Sheets("cc1").Select
Range("a1:a5").EntireRow.Delete
Sheets("cc2").Select
Range("a1:a5").EntireRow.Delete
Sheets("cc3").Select
Range("a1:a5").EntireRow.Delete

Thanks in advance. Diba