How do I also get the macro to quit running if the massage box is displayed?
I'm trying to avoid the user seeing the Run Time error. The message box would
hint the user that a value needs to be placed in B4. So if no value is in B4
then the message box should come up and the macro should stop running.

"Chip" wrote:

Yes....simply add this

If IsEmpty(Sheets(1).Range("B4")) Then
MsgBox("Name Not Defined")
End If