Compile OverFlow Error

[Neal Zimm]

Hi -
Am newish developer.
Building a large Addin.

How do you correct a compile overflow error ?
Thanks.

 

[Dick Kusleika]

How do you correct a compile overflow error ?

Just a guess: Change Dim x as Integer to Dim x as Long

 

[Jim Thomlinson]

Possibly
Const MyBigNumber as integer = 1000000
Integer is limited to +/-32k

 

[Neal Zimm]

Thanks, stupid oversight on my part.

--
Neal Z

Just a guess: Change Dim x as Integer to Dim x as Long

 

[Neal Zimm]

Thanks, stupid oversight on my part.
--
Neal Z

Possibly
Const MyBigNumber as integer = 1000000
Integer is limited to +/-32k