Excel 2003 VBA: Delete row if not SS#

Topic

New Reply

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

Reply | Quote

Replies

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. :cheers:

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.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote