Microsoft KB Archive/160587

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

Article ID: 160587

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q160587



SYMPTOMS
When you type a mathematical formula 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. The following example illustrates the syntax to use: ?200&*200



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.

