Range.Hidden property

Returns or sets a Variant value that indicates if the rows or columns are hidden.

Syntax

expression.Hidden

expression A variable that represents a Range object.

Remarks

Set this property to True to hide a row or column. The specified range must span an entire column or row.

Don't confuse this property with the FormulaHidden property.

Example

The following example hides column A on Sheet1.

Worksheets("Sheet1").Columns("A").Hidden = True

The following example unhides all columns and rows.

Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False