Microsoft KB Archive/184177

= XL98: Run-time Error Evaluating Immediate Window Expression =

Article ID: 184177

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184177



SYMPTOMS
When you type a mathematical formula that is similar to the following in the Immediate window in the Visual Basic Editor

?200*200

you receive the following error message:

Run-time Error 6:

Overflow



CAUSE
This problem occurs when the result of the calculation you type in the Immediate window is too large to be represented by an Integer type expression; the result exceeds the limit for the Integer type expression.



RESOLUTION
To resolve this behavior, assign the Long integer data type to any mathematical functions that return a value larger than 32,767. To assign the Long integer data type in the Immediate window, use the ampersand (&) character. For example, use the following syntax:

?200&*200



STATUS
This behavior is by design of Microsoft Excel 98.



MORE INFORMATION
Long integer variables are stored as signed 32-bit (4-byte) numbers that range in value from -2,147,483,648 to 2,147,483,647. The type declaration character for Long is the ampersand (&) character.

Integer variables are stored as 16-bit (2-byte) numbers that range in value from -32,768 to 32,767.

