O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required