I'm designing a program that will calculate the number of Miliseconds in a Millenium and everything in between. As you can tell, I need a way to store and work with VERY large numbers. I tried using Double and it's giving the a Run-Time Error 6 - Overflow. That shouldn't be happening especially since it gives it trying to store the value 60,000. Here's my code. PLEASE HELP !!
Public zConst_Time(12, 12) As Double
zConst_Time(3, 1) = 1000 * 60
It gives the error on this line. What's going wrong?