Skip to main content

Range.Hidden property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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.


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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>