Thu 3 May 2007, 16:36Delegate Femi said...
Femi has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Overflow error for long integer
The MS VB help file has an example of an overflow error, i.e.
dim x as long
x = 2000 * 365
Why does this produce an overflow error when x would be 730,000, which seems to be within the range of
-2,147,483,648 and 2,147,483,647?
Wed 23 May 2007, 13:50Trainer Carlos said...
RE: Overflow error for long integer
Hi Femi
I have looked at this and even searched the net and I think there is an error on the example.
The dim should have read:
Dim X as Integer
All the examples I found used Integer, and the Help file example works perfectly using it.
Carlos
