Good Afternoon,

I've used the same code below in several of my previous workbooks. I use it
to enforce entry into a worksheet related cell and make sure it's completed
before proceeding. This particular instance is housed with a larger macro,
but it's acting different than past applications.

The person using this worksheet enters data and then presses a custom send
button. This message pops up if M20 is not completed. In past workbooks, the
code simply halts and they just enter the data to satisfy the request and
press send again. This is not the case with this use. It's stopping, but
deleting their data.

Is there a simple command I could use to request Clear contents = False - or
something of that nature so it exists sub, but doesn't take their data with
it?

Thanks - Jenny B.

If ActiveSheet.Range("m20") = "" Then
MsgBox "Please Review Legal Name and Document in Comments."
Exit sub
End If