Automatic Macro Stop

Hello

You can add a dialog box to stop the macro to allow for correcting the empty cell

If MsgBox("Warning, correct the empty cell!!!", vbYesNo, "") = vbNo Then
Exit Sub
End If

Or you can place this in a cell that you will name "empty_cell_check" with a formula that returns true when the cell is empty

Set myRange = Worksheets("sheet").Range("empty_cell_check")
If myRange <> 1 Then
If MsgBox("You must enter information?", vbYes, "") = vbYes Then
Exit Sub
End If

It's up to you to decide what works best for your case.

I had indeed placed the exit sub, but not in the right place, that's why it wasn't working!!
Thank you for your help!!