Worksheet Object

Multiple objects Worksheet Multiple objects

Represents a single worksheet in a workbook.

Using the Worksheet Object

The following properties return a Worksheet object:

• The Range object's Worksheet property

• The Spreadsheet , Window, and Workbook objects' ActiveSheet property

• The Worksheet object's Next and Previous properties

• The Worksheets collection's Add method and Item property

Properties | Application Property | AutoFilter Property | AutoFilterMode Property | Cells Property | Columns Property | CommandText Property | ConnectionString Property | DataMember Property | EnableAutoFilter Property | FilterMode Property | Index Property | IsDataBound Property | ListObjects Property | Name Property | Names Property | Next Property | Parent Property | Previous Property | ProtectContents Property | Protection Property | ProtectionMode Property | Range Property | Rows Property | StandardHeight Property | StandardWidth Property | Type Property | UsedRange Property | Visible Property

Methods | Activate Method | Calculate Method | Copy Method | Delete Method | Evaluate Method | Move Method | Paste Method | Protect Method | Refresh Method | Select Method | ShowAllData Method | Unprotect Method

Parent Objects | AutoFilter Object | ISpreadsheet Object | ListObject Object | ListObjects Collection | Protection Object | Range Object | Spreadsheet Object | Window Object | Workbook Object | Worksheet Object

Child Objects | AutoFilter Object | ListObjects Object | Names Object | Protection Object | Range Object | Workbook Object | Worksheet Object