XL97: Names Collection Result Is Incorrect or Returns an Error

• Microsoft Excel 97 for Windows

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords          : kberrmsg kbprg
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbworkaround