Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Nov 2003
    Location
    Tampa, Florida, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2003 VBA: Delete row if not SS#

    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

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    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.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •