excel delete ever other vba

The solution for “excel delete ever other vba” can be found here. The following code will assist you in solving the problem.

Get the Code! 
Sub Delete_Every_Third_Row()

Dim Rng As Range

Set Rng = Application.InputBox(“Select the Range (Excluding headers)”, “Range Selection”, Type:=8)

For i = Rng.Rows.Count To 1 Step -3

If i Mod 3 = 0 Then

Rng.Rows(i).Delete

End If

Next i

End Sub

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

exit sub vba

Bym0nxt3r

The solution for “exit sub vba” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]