Hi
I have the following routine to print from my worksheet:
Sheets("BACS Ltr").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Data Input").Select
Range("C5").Select
What I want is that if the user has not entered data into the following fields then the process should stop and a message displayed to advise the user:
"Please complete all data before proceeding"
Fields to be completed (all in sheet "Data Input")
C5
C18
C19
C27
G29
Can anyone help? Thanks
I have the following routine to print from my worksheet:
Sheets("BACS Ltr").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Data Input").Select
Range("C5").Select
What I want is that if the user has not entered data into the following fields then the process should stop and a message displayed to advise the user:
"Please complete all data before proceeding"
Fields to be completed (all in sheet "Data Input")
C5
C18
C19
C27
G29
Can anyone help? Thanks