UnhideCells

Exposes any hidden cells in the specified workbook or worksheets by making visible any hidden rows or columns.

Applies to

IOAKAddIn, IOAKAPI

SYNTAX

Set result1 = expression1.UnhideCells

expression2.UnhideCells(BookOrSheets)

expression1   Required.  An expression that returns an IOAKAddIn object.

expression2   Required.  An expression that returns an IOAKAPI object.

result1   An OAKResult enumeration indicating the success or otherwise of the action.

BookOrSheets        Required.  One of

•an Excel workbook object

•an Excel worksheet object

•a collection of worksheet objects

•an array of worksheet objects

Remarks

When applied to an IOAKAddIn object, the UnhideCells method activates the same dialog box as is presented when the Unhide cells command  is selected manually from the OAK user interface.  The action that follows is controlled by the data gathered by the dialog box from the user.

When applied to an IOAKAPI object, the UnhideCells exposes any hidden cells on the workbook or worksheet or worksheets specified by the parameters submitted to the method.

Example

To expose any hidden cells in the active worksheet:

MyOakApi.UnhideCells ActiveWorksheet