Hello,
In the execution of a VBA code a "Capacity overrun" error occurs on my "CNm" variable type Long at the following step of the code:
Attachment 867685
We can see in the variables window values that Nm=183. Making the operation by hand doesn't give a CNm result over the Long capacity.D?passement de capacit? CNm.jpg
Does someone have an idea about the problem cause?
I see only hacking. Are you agree?
Thanks by advance.
With best regards,
Declare Nm as Long, not Integer or specify your first literal value as a Long like this:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
It's vba quirk. Math operator (*, + etc), when supplied with INT value will return INT and will cause this error.
Try something like...
By using CLng on one of the int value, it will force calculation to return long type and avoid that error.Please Login or Register to view this content.
EDIT: You can test this by doing simple math operation CNm = 183 * 183 will generate Overflow error. But you can use CNm = CLng(183) * 183 to return result without error. Also note division and subtraction won't cause this error.Go figure.
Last edited by CK76; 04-30-2024 at 12:45 PM.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Thanks for the answers. Both are good solutions but I don't understand why does the error occur only at Nm=183!!
It means that my Integers are coded on 15bits only and not 2bytes as they should be!!
In fact, the error occurs at Nm=183 when CNm should be 16471 and goes over the signed values on 15bits (16384). With Nm=182, the program gives CNm=16290 without error.
As positive integer values are coded on 16bits (2bytes) they go up to 32768 and the error should occurs at Nm=258.
Can you confirm that the actual error shows an abnormal range for an Integer value?
The first part of your expression evaluates to 181 * 182 which is 32942 - more than an integer value.
Ok! Thank you!
But I have checked with the following code:
Dim Nm As Long
Nm=181*182
and the Capacity overrun occurs on Nm calculation!... Any suggestion?
It's the same problem. Use:
Please Login or Register to view this content.
Sorry, but it is not the same problem because I shouldn't have to translate the format (with "&") to make the result of the operation fit with a Long format. In fact, the size of the result is in the range of a Long variable. Why do I have to translate the operation?
Like I stated previously in post #3. INT * INT or INT + INT that result in Long type will generate that error. As VBA tries to return INT type rather than Long type.
What you set the variable that will hold the result have no relevance here. It's the data type of number being applied operator that will cause this.
It's VBA quirk. It is the same underlying issue.
I didn't precise that my code works with all others numeric values of Nm<183... it is well a problem of capacity range when Nm=183. So, in my case INT * INT or INT + INT do not always make an error. Why don't I have an error with smaller Nm values?
I understand that the result of the operation with Integers must not rise above 32767 whatever the storage variable type. But now, I don't understand why the code hereunder makes a Capacity overrun error:
'
Dim Nm As Long
Nm=181*182
'
Because there is an implicit variable of type Integer that holds the result(s) of the expression on the right hand side before that is assigned to your variable. (In other words, yes it is the same problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks