Programming Excel with VBA and .NET

Worksheets and Worksheet Members

Use the Worksheets collection to create new and get existing worksheets in Excel. Use the Workbook object’s Worksheets method to get a reference to this collection. Use the Worksheet object to activate and work with ranges on individual worksheets. The Worksheets collection and Worksheet object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only
2 Object and collection
Activate	Add 1	Application 2
AutoFilter	AutoFilterMode	Calculate
Cells	ChartObjects	CheckSpelling
CircleInvalid	CircularReference	ClearArrows
ClearCircles	CodeName	Columns
Comments	ConsolidationFunction	ConsolidationOptions
ConsolidationSources	Copy 2	Count 1
Creator 2	CustomProperties	Delete
DisplayPageBreaks	DisplayRightToLeft	EnableAutoFilter
EnableCalculation	EnableOutlining	EnablePivotTable
EnableSelection	Evaluate	FillAcrossSheets 1
FilterMode	HPageBreaks 2	Hyperlinks
Index	Item	ListObjects
MailEnvelope	Move 2	Name
Names	Next	OLEObjects
Outline	PageSetup	Parent 2
Paste	PasteSpecial	PivotTables
PivotTableWizard	Previous	PrintOut 2
PrintPreview 2	Protect	ProtectContents
ProtectDrawingObjects	Protection	ProtectionMode
ProtectScenarios	QueryTables	Range
ResetAllPageBreaks	Rows	SaveAs
Scenarios	Scripts	ScrollArea
Select ...