Check Cell Content before continuing...
I'm sorry, I ran into a compile error on my syntax right away. Any advice?
If Range("Q44").Value = "Fill in..." Or _
Range("F47").Value = Range("AB2").Value _
Thank you for your patience.
Christopher McCune
"Bill Renaud" wrote:
Try something like this (untested): Replace A1OriginalValue and
B1OriginalValue with your actual values (numbers, strings, etc.).
If Range("A1").Value = A1OriginalValue Or _
Range("B1").Value = B1OriginalValue _
Then
MsgBox "Error. Cell A1 and/or B1 has not changed.", _
vbCritical + vbOKOnly, _
"Check Cell A1 and B1"
Else
'Do macro.
End If
--
Regards,
Bill Renaud
|