MsgBox application.fact(10)


--

HTH

Bob Phillips

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

"DanielWalters6" wrote in message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters