This syntax works for me:

Application.WorksheetFunction.Fact(5)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

skrev i en meddelelse
m...
I am trying to code the factorial function in VBA in Excel.
I know I can use the FACT() in the worksheet, but somehow I can't use
the same function when I am writing the VBA. It gave error and said
"sub or function not defined". I did macro recording and copy the
code to my sub-function and try to run it, it gave error again. Can
someone help? Thanks.