View Single Post
  #5   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 not sure what I did, but your version works. (What was changed?)

Can you tell me how to stop the Macro if the 'then' condition is met, and
continue if it isn't?

Thank you,
Christopher McCune
PS: "Fill in..." is the cell's content. It's specific label is next to it.

"Bill Renaud" wrote:

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