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 alphabetically by method name).
| Method | Objects |
|---|---|
| Add | PivotCaches, PivotTables |
| CalculateFull | Application |
| CreateNewDocument | Hyperlink |
| CreatePivotTable | PivotCache |
| Format | PivotTable |
| GetPhonetic | Application |
| PointsToScreenPixelsX | Window |
| PointsToScreenPixelsY | Window |
| RangeFromPoint | Window |
| ReloadAs | Workbook |
| ResetTimer | PivotCache, QueryTable |
| ScrollIntoView | Pane, Window |
| SetPhonetic | Range |
| WebPagePreview | Workbook |