Microsoft KB Archive/174201

= XL97: Names Collection Result Is Incorrect or Returns an Error =

Article ID: 174201

Article Last Modified on 6/12/2007

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.