View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default 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