I have a macro that opens several files, calls a macro, and needs to be able to save the file as a new name once fixed. The code I need should notify the user they are about to save the file with a new name if an error was found.
If Sheets("ErrorSheet").Range("A2") = "" Then
MsgBox "There...