Range.Hidden property (Excel)

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



expression A variable that represents a Range object.


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.


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.