I have what I thought was easy enough, but I am struggling with the syntax.
I want my macro to check if a cell is blank before running the rest of the code. If the cell is blank, then pop up a message box and stop the rest of the macro, if its not blank, then continue the macro.
I am not sure what to put between Exit Sub and My code for the macro I want to run.
If Worksheets("Instructions").Range("C3").Value = "" Then
MsgBox "Missing Date"
Exit Sub
My code
End Sub
I want my macro to check if a cell is blank before running the rest of the code. If the cell is blank, then pop up a message box and stop the rest of the macro, if its not blank, then continue the macro.
I am not sure what to put between Exit Sub and My code for the macro I want to run.
If Worksheets("Instructions").Range("C3").Value = "" Then
MsgBox "Missing Date"
Exit Sub
My code
End Sub