Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
...Blank values in Column A, AND "False" in column i...
In addition, your note says to use "And", but your code is using "Or." Could that be another source of your problem? HTH Dana DeLouis "Gauthier" wrote in message ... 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 | |
|
|
![]() |
||||
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 |