Knowledge Base

XL97: Names Collection Result Is Incorrect or Returns an Error

Article ID: 174201

Article Last Modified on 6/12/2007

Microsoft Excel 97 Standard Edition

This article was previously published under Q174201

SYMPTOMS

When you right-click a worksheet, click Move or Copy to move or copy a worksheet to another workbook, and then run a Visual Basic for Applications procedure that uses the Names collection, the collection returns incorrect results.

In addition, if you use the Count property of the Names collection as an index for the Names object, the following error message appears:

Run-Time error '424'
Object required.

CAUSE

This problem occurs when the following conditions are true:

You add a watch expression (click Add Watch on the Debug menu) for the Names collection. -and-
You expand the Watch pane to view the Names properties.

WORKAROUND

To work around this problem, do not expand the Watch pane.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Keywords: kbbug kberrmsg kbprogramming KB174201