MsgBox Application.Fact(5)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Joe Farruggio" wrote in message
...
Hi
I have written a macro in which i need to call the spreadsheet function
Fact. This gives me an error. Most of the spreadsheet functions are
simply called by using their names but not this one. Anyone have any
ideas on how to do this. By the way using the Fact function in a work
sheet does fine.