Placing macros within the IF condition
As I said, if it is modifying the sheet or cells it cannot be called from a
worksheet function.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Sonia" wrote in message
...
The macro is not being used to modify the sheet. based on the value in
Column
A the respective macro has to be run. ( the macro is to only open another
file ).
Please let me know which function I can use in the IF function to run the
macro.
"Bob Phillips" wrote:
You cannot run a macro in an IF Function if that macro tries to modify
the
sheet or cells in any way. If it is a function that returns a result then
that is okay, simply
=IF(A1=1,Function1, IF(A2=2,Function2, etc.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Sonia" wrote in message
...
Hi...
I would like to run the below condition in excel.
If value of column A=1 then run macro A
If value of column A=2 then run macro B
If value of column A=3 then run macro C
Please help..
Bye for now
Sonia
|