XL98: Run-time Error Evaluating Immediate Window Expression (184177)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
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
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:
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.
REFERENCES
For more information about Data types, click the Office Assistant, type
Data Types, click Search, and then click to view "Using Data Types
Effectively."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kberrmsg kbprb kbProgramming KB184177 |
---|
|