Hi dxider

Having issues with getting this to run? #NAME? error in C:C. As for the "Restricted" class, there were 740 old records in the spreadsheet and I'll modify them to "Restricted X", as going forward that class shouldn't occur again. Trouble is when I edited the cell entry, the code popped up with the 4th line regEx As New RegExp highlighted and I'm in a viscous loop in that I can't close the vba box to re-edit or whatever and get Compile Error?? I can't even close the program now aahh!!That's the nature of vba and why I hate it, but that's only because I don't know what I'm doing, and deserve what I get LOL