delete rows with blank cell

[Godders199]

Hello, I have written the following code to delete all rows where the cell in column J is Blank, but currently it is deleting all rows

Dim uLastRow As Long
Dim u As Long
uLastRow = Cells(Rows.Count, "d").End(xlUp).Row
For u = uLastRow To 1 Step -1
If Cells(u, "j").Value = "" Then
Rows(u).Delete
End If
Next u

I do have column A hidden, but even unhiding that has the same result. is there any reason why it is deleting all rows?

 

[davesexcel]

Are the cells merged?
How are the cells in Column J filled?

 

[Godders199]

hi, no merged cells, the following formula is in column J, so is it just not seeing the "match" and deleting all?

=IF(COUNTIFS('Outstanding 2ndline'!A:A,HFC!D2)>0,"match","")

 

[Godders199]

Hi, have just worked out if i do this as a separate marco , it works, just does not work when combined with the formatting and adding the above formula.