VBA long overflow
- by HK_CH
Hi I am trying to do some maths with my VBA excel (prime factorization) and I am hitting the limit of the long data type (runtime error 6 Overflow).
Is there any way to get around this and still stay within VBA? (I am aware that the obvious one would be to use another more appropriate programming language)
Thanks for help in advance!
Thank you, it works in so far that I am able to get the big numbers into the variables now. However when I try to apply the MOD function (bignumber MOD 2 for example) it still fails with error message runtime error 6 Overflow.