Thanks for your previous post, with a few modifications I got the error
message to pop up, however something is still incorrect... The message
appears whether or not the address info is in C5:C8.
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C5:C8")) Is Nothing Then
Application.EnableEvents = False
If Range("C5:C8") = "" Then Target = ""
MsgBox "To continue ALL ADDRESS INFO MUST BE ENTERED"
End If
Application.EnableEvents = True
End Sub