I have tests on spreadsheet to see if data is missing and want to save the
spreadsheet using a macro, but first test to see if there is an error
message. I am only a basic user of macro's and use them through record. I
have found out how to put a message box on screen, but want the box to appear
when there is an error, but to save when there are no errors.