I want to delete every alternate row from my work sheet. I tried recording macro, but it only deletes a particular row as shown below (Row 4:4). How can this macro be converted to a more versatile one?
Keyboard Shortcut: Ctrl+q
Just use the macro below:
Dim startAtRow, endAtRow, rowCounter As Long
startAtRow = 2
endAtRow = 100
For rowCounter = startAtRow To endAtRow
Thanks to rizvisa1
for this tip on the forum.
This document, titled « Excel - A macro to delete alternate rows », is available under the Creative Commons
license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM