WorkbookBase.Sheets Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a Sheets collection that represents all the sheets in the workbook.
public:
property Microsoft::Office::Interop::Excel::Sheets ^ Sheets { Microsoft::Office::Interop::Excel::Sheets ^ get(); };public Microsoft.Office.Interop.Excel.Sheets Sheets { get; }member this.Sheets : Microsoft.Office.Interop.Excel.SheetsPublic ReadOnly Property Sheets As SheetsProperty Value
A Sheets collection that represents all the sheets in the workbook.
Examples
The following code example uses the Sheets property to display the number of sheets in the workbook.
This example is for a document-level customization.
private void DisplayNumberOfSheets()
{
MessageBox.Show("There are " + this.Sheets.Count +
" sheets in this workbook.");
}
Private Sub DisplayNumberOfSheets()
MsgBox("There are " & Me.Sheets.Count & _
" sheets in this workbook.")
End Sub
Remarks
The collection includes worksheets, charts, dialog sheets and macro sheets in the workbook.