Deleting alternae rows
Solved/Closed
abthak
-
Feb 14, 2010 at 03:12 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 14, 2010 at 08:41 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 14, 2010 at 08:41 AM
Related:
- Deleting alternae rows
- Excel duplicate rows n times ✓ - Excel Forum
- Copy row and insert n times ✓ - Office Software Forum
- Excel macro to insert rows between data - Excel Forum
- Excel duplicate rows based on cell value ✓ - Excel Forum
- Excel vba copy rows to another worksheet based on criteria ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 14, 2010 at 07:50 AM
Feb 14, 2010 at 07:50 AM
Sub deleteAlternateRow() Dim startAtRow, endAtRow, rowCounter As Long startAtRow = 2 endAtRow = 100 For rowCounter = startAtRow To endAtRow Rows(rowCounter).Select Selection.Delete Shift:=xlUp Next End Sub
Feb 14, 2010 at 08:23 AM
It has worked.
Thanks a lot. :)
Feb 14, 2010 at 08:41 AM