You can call a function if that function just returns a result, but not
anything that looks to change some attribute of the worksheet, such as font,
colour. These type of functions are called User Defined Functions (UDF).

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"David Henderson" wrote in message
...
Hi all
Please could somebody tell me if it is possible to call a macro from an
if()
function

eg if (condition true, macro1,macro2)
I am thinking not, but ....?
Any help would be much appreciated
Thanks in advance
David