View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Variable overflow

why would you even think about looping over a number like that. The value
returned by combin only has 15 significant digits, so you are not getting the
exact number any how

Anyway, even if it took 1 millionth of a second to do each loop, it would
take around 132 years to complete the loop. I could be off by a couple of
years.

--
Regards,
Tom Ogilvy


"Daniel" wrote:

Thanks, Using double still poses a problem. I would using maxlen in a
loop and reducing it by 1 after each iteration.


Regards
Dk

*** Sent via Developersdex http://www.developersdex.com ***