Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Mar 07 In MS Office Category.

  
Question Answered By: Jakson Williams   on Mar 07

I am supposing that the action you want to perform is in the sheet name "Sheet1"
but change to whatever you need.

I would simply try the following

Sub mydelete()
Dim i As Integer
For i = 2 To 2000 Step 4
Worksheets("Sheet1").Rows(i).Delete
Next i
End Sub
Hope this helps

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Deleting Non-consecutive rows in VBA Or get search suggestion and latest updates.


Tagged: