Export (0) Print
Expand All
Expand Minimize

Workbook.Worksheets Property

Office 2007
Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.

Syntax

expression.Worksheets

expression   A variable that represents a Workbook object.

Remarks

Using this property without an object qualifier returns all the worksheets in the active workbook.

This property doesn’t return macro sheets; use the Excel4MacroSheets property or the Excel4IntlMacroSheets property to return those sheets.

Example

This example displays the value in cell A1 on Sheet1 in the active workbook.

Visual Basic for Applications
MsgBox Worksheets("Sheet1").Range("A1").Value

This example displays the name of each worksheet in the active workbook.

Visual Basic for Applications
For Each ws In Worksheets
    MsgBox ws.Name
Next ws

This example adds a new worksheet to the active workbook and then sets the name of the worksheet.

Visual Basic for Applications
Set newSheet = Worksheets.Add
newSheet.Name = "current Budget"



Community Additions

ADD
Show:
© 2014 Microsoft