View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chris T-M Chris T-M is offline
external usenet poster
 
Posts: 43
Default 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