View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derick Hughes Derick Hughes is offline
external usenet poster
 
Posts: 4
Default Variable overflow


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 ***