Check Cell Content before continuing...
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
|