use a double. Numbers in the Excel sheet are doubles
from the immediate window:
a = application.combin(60,20)
? a
4.1918445058055E+15
--
Regards,
Tom Ogilvy
"Derick Hughes" wrote:
Is there a way for a large number to be assigned to a variable? For
example:
Dim maxlen as Currency
Sub
maxlen = application.worksheetfunction.combin(60,20)
End sub
maxlen produces an overflow error. Is there a way around this?
Regards
Dk
*** Sent via Developersdex http://www.developersdex.com ***