Microsoft KB Archive/157232

= XL97: Incorrect Definitions Displayed in Object Browser =

Article ID: 157232

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q157232



SYMPTOMS
The Details Pane in the Microsoft Object Browser displays incorrect information for the following Add methods:     Object/Method    Currently displays        Should display --  ---      PivotItems.Add   Sub Add(Name as string)   Function Add(Name as String) as PivotItem

Worksheets.Add  Sub Function([Before],    Function Add([Before], [After],[Count],         [After],[Count],[Type])                    [Type]) as Object         as Worksheet The Add method for the PivotItems class is listed as a Sub when it should be listed as a function that returns a PivotItem object. The Add method for Worksheets shows that it returns an Object when it should show that it returns a Worksheet object.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.



MORE INFORMATION
You can use the Object Browser in Microsoft Visual Basic for Applications to search for a particular Class, Object, Property, Method, Constant, or Event. You can search project files you created or project files from other libraries. When you are in the Visual Basic Editor, press the F2 key or click Object Browser on the View menu to run the Object Browser.

