Deleting text from Column VBA

[P_85]

sorry for posting so quickly again. Just can't get my head around VB!

Ok so what I am trying to do is delete any rows that has text stored in column A. I do not what to look for a particular text, I want to delete anything that is a text in column A.

I have had a searched around Google but everything seems to be designed towards looking for a particular text.

I'd be grateful for any help on this matter.

Thanks

 

[VoG]

Try

Sub DelText()
On Error Resume Next
Columns("A").SpecialCells(xlCellTypeConstants, xlTextValues).EntireRow.Delete
End Sub

 

[P_85]

Thanks very much, worked a treat!