Edit

Share via

Range.Hidden property (Excel)

  • Article

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

This example hides column C on Sheet1.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.