Methods with arguments that have been added for Microsoft Excel 97 are listed in the following table. For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics:
New Properties and Methods (by Object)
New Properties and Methods (Alphabetic List)
Changes to Visual Basic in Microsoft Excel for Windows 95
| Method | Objects | New arguments |
|---|---|---|
| Add | OLEObjects | Left, Top, Width, Height |
| ApplyDataLabels | Chart, Series | AutoText, HasLeaderLines |
| ApplyDataLabels | Point | AutoText |
| AutoFilter | Range | VisibleDropDown |
| CheckSpelling | Chart, Range, Worksheet | IgnoreInitialAlefHamza, IgnoreFinalYaa, SpellScript (these arguments aren't used in U.S. English Microsoft Excel) |
| Find | Range | MatchControlCharacters, MatchDiacritics, MatchKashida, MatchAlefHamza (these arguments aren't used in U.S. English Microsoft Excel) |
| Open | Workbooks | AddToMru |
| OpenText | Workbooks | TextVisualLayout (not used in U.S. English Microsoft Excel) |
| PivotTableWizard | Worksheet | BackgroundQuery, OptimizeCache, PageFieldOrder, PageFieldWrapCount, ReadData, Connection |
| PrintPreview | Chart, Charts, Range, Sheets, Window, Workbook, Worksheet, Worksheets | EnableChanges |
| RegisteredFunctions | Application | Index1, Index2 |
| Replace | Range | MatchControlCharacters, MatchDiacritics, MatchKashida, MatchAlefHamza (these arguments aren't used in U.S. English Microsoft Excel) |
| Run | Application | Now uses a variable-length argument array |
| SaveAs | Chart, Workbook, Worksheet | AddToMru, TextCodepage, TextVisualLayout (the last two arguments aren't used in U.S. English Microsoft Excel) |
| SetDefaultChart | Application | Gallery |
| Sort | Range | SortMethod, IgnoreControlCharacters, IgnoreDiacritics, IgnoreKashida (the last three arguments aren't used in U.S. English Microsoft Excel) |