How about
If Range("A1").Value = "Yes" Then Call Macro2
or am I missing something obvious?
"Darin Kramer" wrote in message
...
Howdie!
I need to run a macro that, depending on the result in a cell, runs
another Macro (second macro is just a hide of a column)
So for example, when the user runs Macro 1 it needs to check the value
in Cell A1. If A1 = Yes, then run Macro number 2. If the value in a1 =
No, then dont run any Macros and the first macro can be stopped.
Any ideas?
Thanks and Regards
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!