In Microsoft Excel 2000, many new Visual Basic for Applications methods have been added to existing objects. These methods are listed in the following table (sorted by object name).
| Object | Methods |
|---|---|
| Application | CalculateFull, GetPhonetic |
| Hyperlink | CreateNewDocument |
| Pane | ScrollIntoView |
| PivotCache | CreatePivotTable, ResetTimer |
| PivotCaches | Add |
| PivotTable | Format |
| PivotTables | Add |
| QueryTable | ResetTimer |
| Range | SetPhonetic |
| Window | PointsToScreenPixelsX, PointsToScreenPixelsY, RangeFromPoint, ScrollIntoView |
| Workbook | ReloadAs, WebPagePreview |