XL97: Run-time Error Evaluating Immediate Window Expression (160587)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

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.

REFERENCES

For more information about Long integer data types, click the Index tab in Visual Basic for Applications Help, type the following text

long



and then double-click the selected text to go to the "Long data type" topic.

For more information about Integer data types, click the Index tab in Visual Basic for Applications Help, type the following text

integer

and then double-click the selected text to go to the "Integer data type" topic.

Modification Type:MajorLast Reviewed:10/21/2000
Keywords:kberrmsg KB160587