You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
-
Changing the declaration worked. I changed a bunch of "as Integer" to "as Long".
Thanks, group.
It now works without crashing.
-
Integer will crash it. That only goes up to 32k (2^15, maybe 2^15 - 1 to be precise), so 40k is too big. I rarely define any whole...
-
There's VBA code that uses this value in many places.
However it's only declared one time in a Module: Global giCI as Long
Which I...
-
It took hours for me to find it because it SHOULDN'T crash. One record had a value of 40,000 for a certain column. The data type is Long...
Like.
Integer will crash it. That only goes up to 32k (2^15, maybe 2^15 - 1 to be precise), so 40k is too big. I rarely define any whole...