Show/Hide related procedures in class Range (Excel VBA)
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
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()
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.
Draws tracer arrows to the direct dependents of the range.
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
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
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
Draws tracer arrows to the direct precedents of the range.
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