Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error - End If Without Block
Hi There...for the likes of me, i just can't get this to work!
Can anyone help? Sandi the following is a snippet of my module that won't work - i've already declared "Dim X As Long" in a previous procedure - and incidentially, i started the range with column C, because the last two cells in column A are blank: ' CODE TO DELETE ROWS WHICH CONTAIN BLANK VALUES IN COLUMN A, AND "FALSE" IN COLUMN I For X = Range("C65536").End(xlUp).Row To 1 Step -1 If Range("A" & X) = "" Or _ Range("I" & X) = "FALSE" Then _ Range("A" & X).EntireRow.Delete End If Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile Error: Block If without End if | Excel Discussion (Misc queries) | |||
VBA error - End If without Block If | Excel Worksheet Functions | |||
Error 91, Object var or With block not set | Excel Programming | |||
Runtime error 91: Objust variable or with block.... | Excel Programming | |||
compile error: block if without end if | Excel Programming |