Macro to deleting SSN from each Sheet

[dziw]

I have a large server full of excel files that include SSN numbers and I have to delete them from every file. Each Excel file has multiple Sheets named differently. The problem is that this macro isn't running on every sheet. What am I doing wrong???

Please Login or Register  to view this content.

The difference in replacements is because some SSNs are stored as "xxx-xx-xxxx" and others as "xxxxxxxxx" in a 000-00-0000 number format.


Thanks so much!

[dziw]

Oops figured out my problem!

I needed to select each sheet in turn

For Each mysht In ActiveWorkbook.Worksheets
mysht.Select