Issues with SpecialCells(xlCellTypeBlanks).EntireRow.Delete

[dpmaki]

I'm running the following VBA code:
Range("T:T").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
As you can see in the screenprint there are clearly blank values in the T:T range, but when I run the code I get the following message:

Run-time error '1004':
No cells were found.

I've used this code several times in the past, so I'm not quite sure what is going on here.
Any help with this would be greatly appreciated.

 

[VoG]

Perhaps those "empty" cells contain spaces. Try selecting the column then running the TrimAll macro http://dmcritchie.mvps.org/excel/join.htm