| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting rows from mutliple sheets
Sub Deleting()
Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets ws.Range("A1:A5").EntireRow.Delete Next ws End Sub Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 09:26:16 -0700, diba wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct across mutliple sheets - deleting row in one sheet | Excel Discussion (Misc queries) | |||
| MATCH() or VLOOKUP() across mutliple 65K sheets possible? | Excel Discussion (Misc queries) | |||
| Deleting rows from all sheets in an array? | Excel Programming | |||
| inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
| deleting mutliple rows in different ranges at same time | Excel Programming | |||
Hybrid Mode
