Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
<<Can you tell me how to stop the Macro if the 'then' condition is met, and
continue if it isn't? Leave the 'then' condition empty and have code in the 'else' part of the clause only, or revise the logic as follows: Sub Test() If Range("Q44").Value < "Fill in..." And _ Range("F47").Value < Range("AB2").Value _ Then 'Your code here. End If End Sub Except that your OP (original post) said: <<IF new, then continue macro. IF unchanged, then display error... -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check if content in cell is an integer | New Users to Excel | |||
Check if content in cell is an integer | New Users to Excel | |||
VBA cell content check | Excel Programming | |||
text continuing in next row in a merge cell | Excel Worksheet Functions | |||
How to check a cell for content before running macro. | Excel Programming |