Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do delete every second Row
Like we need another way to do this. This goes forward through the rows:
Set MyRange = Range("A9") Do While MyRange < "" MyRange.Offset(1, 0).EntireRow.Delete Set MyRange = MyRange.Offset(1, 0) Loop -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "John" wrote in message ... What code would I use to delete every second Row starting at Row 10 i.e. delete Row10; 12; 14 etc? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |