One more question. When I run the program, it works great. But when I delete the column that the original SS# is in, I get the "#ref!" message in the column I designated with the format of 123-45-xxxx. How do I go about not getting the "!ref!" message. Should I use a macro and if so, same program?