Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004 in loop | Excel Discussion (Misc queries) | |||
run time error 1004 in loop | Excel Discussion (Misc queries) | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
Simple problem refering to variable in For ... Next loop ... | Excel Programming |