Why is VBA returning an "Overflow" error? (1 Viewer)
- Thread starter MyTech
- Start date
Thank you Inet for the replacement function.
Thank you Galax for detailing the source of the problem.
Interesting, Microsoft documented in the MSDN library that the MOD operator can handle "any numeric expression".
http://msdn.microsoft.com/en-us/library/gg264708.aspx
Thank you Galax for detailing the source of the problem.
Interesting, Microsoft documented in the MSDN library that the MOD operator can handle "any numeric expression".
http://msdn.microsoft.com/en-us/library/gg264708.aspx
the_net_2.0
Banned
- Local time
- Today, 12:24
- Joined
- Sep 6, 2010
- Messages
- 812
The funny part about that article is 2 fold:
1) the MSDN articles were copied verbatim from office help files, or vice versa. Whatever cost less money for some poor soul to do by the hour.
2) notice this part of the file:
USUALLY? Well, in MS terms, if you look deep enough into this they're basically saying that the result can't be longer than a LONG. But you're left to figure that out for yourself (as you just did!).
Does it matter? iNet is putting the ABS() function in to cover the scenario where you pass a negative val to the function. If you do pass one, you'll get the MOD number back but with a nice little "-" sign attached to it.
The main point is that you will get undesired results without Abs(). So it wasn't really about having a prefixed minus sign. Remember that minus * minus = plus, so this part
Code:
- (181440 * Int((-5463513391)/181440))
Code:
[COLOR=Red]-[/COLOR] ([COLOR=Red]-[/COLOR]5463521280)
=
[COLOR=Red]+[/COLOR] 5463521280
