View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default 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