Check Cell Content before continuing...
Your code (as follows) compiles and runs fine on my machine (Excel 2000):
Sub Test()
If Range("Q44").Value = "Fill in..." Or _
Range("F47").Value = Range("AB2").Value _
Then
MsgBox "Then"
Else
MsgBox "Else"
End If
End Sub
I don't know how the "Fill in..." will work, however. Maybe it appears this
way in the cell, but the full value is something longer (?).
--
Regards,
Bill Renaud
|