OFF2001: "Run-time Error '6'; Overflow" When You Use Visual Basic for Applications (299846)

The information in this article applies to:

Microsoft Excel 2001 for Mac
Microsoft PowerPoint 2001 for Macintosh
Microsoft Word 2001 for Macintosh

This article was previously published under Q299846

SYMPTOMS

If you use Visual Basic for Applications (VBA) functions in any of the Office 2001 programs listed at the beginning of this article, the calculation may display the following error message:

Run-time error '6';
Overflow

CAUSE

This problem can occur when some long decimal values are used in calculations in VBA.

RESOLUTION

To resolve this problem, download and install the Microsoft Office 2001 Service Release 1 file. To do so, visit the following Microsoft Web site:

http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/download/office2001/update_905.xml&secid=10&ssid=25&flgnosysreq=True

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2001 for Mac Service Release 1.

REFERENCES

For additional information about the Office 2001 Service Release, click the article number below to view the article in the Microsoft Knowledge Base:

294949 OFF2001: Readme for Microsoft Office 2001 for Mac Service Release 1 (SR-1)

Or, visit the Microsoft MacTopia Web site (http://www.microsoft.com/mac) for any additional updates.

Modification Type:	Minor	Last Reviewed:	10/11/2006
Keywords:	kbbug kberrmsg kbfix KB299846