Show/Hide related procedures in class Range (Excel VBA)

This page presents procedures from class Range related to the theme Show/Hide: Hidden, Show, ShowCard, ShowDependents, ShowDetail, ShowErrors and ShowPrecedents

Hidden

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

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.

ActiveCell.Hidden = True

Show

Scrolls through the contents of the active window to move the range into view. The range must consist of a single cell in the active document.

Dim booShow As Boolean
booShow = ActiveCell.Show()

ShowCard

For a cell containing a Linked data type, such as Stocks or Geography, this method causes a card to appear that shows details about the cell (that is, the same card that the user can view by choosing the cell icon).

For ranges of more than one cell, this method only attempts to show the card for the upper-left cell in the range. If that cell does not contain a Linked data type, nothing happens.

Range("E5").ShowCard

ShowDependents

Draws tracer arrows to the direct dependents of the range.

ShowDependents (Remove)

Remove: True to remove one level of tracer arrows to direct dependents. False to expand one level of tracer arrows. The default value is False.

Dim booShowDependents As Boolean
booShowDependents = ActiveCell.ShowDependents

ShowDetail

True if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. Read/write Variant.

This property isn't available for OLAP data sources. If the specified range isn't in a PivotTable report, the following statements are true:

ActiveCell.ShowDetail = True

ShowErrors

Draws tracer arrows through the precedents tree to the cell that's the source of the error, and returns the range that contains that cell.

Dim booShowErrors As Boolean
booShowErrors = ActiveCell.ShowErrors

ShowPrecedents

Draws tracer arrows to the direct precedents of the range.

ShowPrecedents (Remove)

Remove: True to remove one level of tracer arrows to direct precedents. False to expand one level of tracer arrows. The default value is False.

Dim booShowPrecedents As Boolean
booShowPrecedents = ActiveCell.ShowPrecedents