Delete Cells Not Starting with Characters? - Filter Delete Removes Everything ><

[hellothere4]

Hello, I am trying to delete all the cells in row 1 which do not begin with a letter. I have tried to create a macro where I filter for cells not beginning with a sentence, and then deleting them. But, whenever I hit delete ALL my cells are deleted. I don't know of another way to delete all these cells, any help would be appreciated.

 

[njimack]

Press F5. Select Special>Visible Cells Only. Then press delete

Edit: or build it into your macro, something like:
Range("A2:A100").SpecialCells(xlCellTypeVisible).ClearContents