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 ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.