SheetProperty (7.6)

Returns the value of the specified sheet property.

Usage

@SheetProp(<PropertyName>, [<SheetNameOrIndex>])

Argument Name Description
PropertyName The name of the property. Not case sensitive. Only enough characters to uniquely identify the propery need be specified. Valid property names: - AutoFilterMode: true, false - DefaultColumnWidth: - Index: the sheet number - Name: the sheet name - Protected: true, false - Visible: true, false - Type: worksheet, chart, other
SheetNameOrIndex The name or sheet number. Sheet number is zero-based. If a sheet is not specified, the active sheet is checked.