Excel 2003 VBA: Delete row if not SS#

[lawrence_groves]

I have 45000 social security numbers in column A . However there are header rows throughout the list .
I would like a macro that looks at each row and if the field in not a social security number then delete the row

[RetiredGeek]

Lawrence,

If the order of the SSNs is not important you could just sort the list on col A (decending). All the header rows should float to the top. You can delete them and then resort.

If that is not an option let us know how the SSNs are stored, is it just 9 numbers or are there - in there, i.e. xxx-xx-xxxx.