ExcelBanter - View Single Post - Simple For-Loop gives 1004 error using variable to EntireRow.Delete

Thread: Simple For-Loop gives 1004 error using variable to EntireRow.Delete

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

EdMX

EdMX is offline

external usenet poster

Posts: 1

Default

Simple For-Loop gives 1004 error using variable to EntireRow.Delete

Sorry I'm a real newbie to Excel and VB but here goes:
Why does this code give me an error in Excel?

Sub Eds1()
Dim i As Integer
For i = 0 To 200 Step 2
Sheet1.Rows(i).EntireRow.Delete
Next i
End Sub

Reply With Quote

Reply With Quote