Add Method

Adds an object to a collection. For more information, click a collection in the following list.

AddIns

CalculatedFields

CalculatedItems

ChartObjects

Charts

CustomViews

FormatConditions

HPageBreaks

Hyperlinks

Names

OLEObjects

Parameters

Phonetics

PivotCaches

PivotFormulas

PivotItems

PivotTables

PublishObjects

QueryTables

RecentFiles

Scenarios

SeriesCollection

Sheets

Styles

Trendlines

Validation

VPageBreaks

Workbooks

Worksheets