Exit Sub

[galvinpaddy]

Afternoon,

Would anyone be able to tell me why the following does not work?

Please Login or Register  to view this content.

In cell R3 i have the formula that will show X if a condition is met, or stay blank if condition is not met.
So i was expecting the macro to stop running if R3 contained an X, but it does not, it instead continues onto the macro 'Arrive'

Any thoughts please

regards

[Richard Buttrey]

Hi,

Try
If Range("R3") = "X" Then

[Bob Flanagan]

As it is a text comparison, try

Please Login or Register  to view this content.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

[MrShorty]

You have not included the "equal to" condition. Your condition is "greater than (but not equal to) X" Try replacing the > with >= or =.

[davesexcel]

What is "x" ?
Your condition is asking if A3 is greater than the letter x.

[galvinpaddy]

HAHAHAHA
increcible.
The minute you highlighted i had > instead of =, it made instant sense, and, actually works. (how embarrassing lol)

OK, so in addition to this, i would like my VBA to do one of 2 things.

1) If the cell R3 contains "X" then run macro "First"
2) If the cell R3 conatins "X" then run the macro "Second" instead.

Many thanks!

[davesexcel]

Please Login or Register  to view this content.

[Bob Flanagan]

Your request was a bit confusing . Did you want it to run two macros if it contains X or run macro1 if it does and macro2 if it does not?

Please Login or Register  to view this content.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

[galvinpaddy]

Sorry, i was typing in a rush, it should have said;

1) If the cell R3 contains "X" then run macro "First"
2) If the cell R3 does not conatin "X" then run the macro "Second" instead.

But thank-you for the suggestions, i will try them all and feedback!
regards

[galvinpaddy]

Fantastic!!
i have amended my code

Please Login or Register  to view this content.

Which appears to run very nicely, thankyou to all for helping, rep added all round :D