Any positive value can be pretty large...

But in general:

Option Explicit
Sub testme()

Dim myNum As Long
Dim myFact As Long 'Use Double for really big numbers

myNum = 7
myFact = Application.Fact(myNum)
MsgBox myFact

End Sub


Jfarrug wrote:

jfarrug wrote:
Now can anyone tell me how to call the excel "Fact(x)" function from a macro
where x can assume any positive value and is varied while the macro is
running?

"Max" wrote:

(Re-sent, apologies for the unintentioned advance dating)

Think it stands for factorial, e.g.:

4! = 4 x 3 x 2 x 1 =24
3! = 3 x 2 x 1 = 6

and in Excel, you can use FACT() to calculate factorials

If you enter in A1: 4, put in B1: =FACT(A1)
B1 returns 24
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"scorpionest" wrote in message
...
In Statistics or Math, does anyone know what the "!" (exclamation point)
stands for? Please HELP. Thank you!




--

Dave Peterson