Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overflow in VBA, but value < limit
Okay, Iıve declared a value ³total² as Long ...
The following causes an overflow ... Of the long integer ³total² total = 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 But Total = 2 ^ 16 Does not ... Is there a limit to the number of multiply signs I can include in a line?? Obviously, Iım not doing this actual sum in my macro multiplies together a number of variables (a, b, c, e ... Etc) How can I overcome this limitation? Cheers, Brad.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is format overflow? | New Users to Excel | |||
Overflow error.. why? | Excel Discussion (Misc queries) | |||
Overflow Error | Excel Discussion (Misc queries) | |||
VBA overflow | Excel Programming | |||
VBA overflow | Excel Programming |