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