Formula to identify cell as value

[FranktheBank]

Never mind I figured out my on problem.
*****
Hello,

This is my formula in VBA:

For lngI = ActiveCell.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
    With Cells(lngI, "A")
        If Left(Cells(lngI, 11), 1) = "" Then .EntireRow.Delete
        End With
Next

The macro works fine, but the formula is not picking up anything with a '0' (Zero).

I tried

For lngI = ActiveCell.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
    With Cells(lngI, "A")
        If Left(Cells(lngI, 11), 1).value = "" Then .EntireRow.Delete
        End With
Next

but it didn't recognize the '.Value'

Can anyone see the error in my formula?? the macro part is O.K.
__________________________________________________________________

Mod edit : as it's very not a formula, thread moved to appropriate forum !​