ExcelBanter - Compile OverFlow Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Compile OverFlow Error (https://www.excelbanter.com/excel-programming/407917-compile-overflow-error.html)

Neal Zimm

Compile OverFlow Error

Hi -
Am newish developer.
Building a large Addin.

How do you correct a compile overflow error ?
Thanks.
--
Neal Z

Dick Kusleika[_4_]

Compile OverFlow Error

On Tue, 18 Mar 2008 13:07:01 -0700, Neal Zimm wrote:

How do you correct a compile overflow error ?

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

Jim Thomlinson

Compile OverFlow Error

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

Jim Thomlinson

"Dick Kusleika" wrote:

On Tue, 18 Mar 2008 13:07:01 -0700, Neal Zimm wrote:

How do you correct a compile overflow error ?

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

Neal Zimm

Compile OverFlow Error

Thanks, stupid oversight on my part.

--
Neal Z

"Dick Kusleika" wrote:

On Tue, 18 Mar 2008 13:07:01 -0700, Neal Zimm wrote:

How do you correct a compile overflow error ?

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

Neal Zimm

Compile OverFlow Error

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

"Jim Thomlinson" wrote:

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

Jim Thomlinson

"Dick Kusleika" wrote:

On Tue, 18 Mar 2008 13:07:01 -0700, Neal Zimm wrote:

How do you correct a compile overflow error ?

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

All times are GMT +1. The time now is 04:08 AM.