Calling a Macro

[nornrich]

All,

Is there a way to execute a macro based on an "if" statement within an Excel Spreadsheet?

Regards,

Rich......

Richard Nornhold, PE

http://www.personna.com

 

[MintJulep]

Probably.

Assuming that your "macro" is a User Defined Function named MyFunction:

=IF(Logical Test, MyFunction())

 

[IRstuff]

Sure, you just put in the macro name. You do need to define it as a function, and not a sub

TTFN

FAQ731-376