SearchForArrays

Searches a specified area of a worksheet for cells array contants or formulas, selecting any that are found in a multi-area range.

Applies to

IOAKAddIn, IOAKAPI

SYNTAX

result1 = expression1.SearchForArrays

Set result2 = expression2.SearchForArrays(Range1)

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.

result2   A Range consisting of all the arrays found within Range1, or Nothing if no arrays are found

Range1           Required Range.  The range in which to search for arrays.

Remarks

When applied to an IOAKAddIn object, the SearchForArrays method performs the same action as the OAK | Search Selection | Arrays command.   It searches for arrays within the current selection.

When applied to an IOAKAPI object, the SearchForArrays method applies searches for arrays within the the range indicated by the parameter submitted to the method.

Wrinkles

When applied to an IOAKAddIn object, the SearchForArrays method follows the One-cell rule.  When applied to an IOAKAPI object, it does not: if supplied a Range parameter describing a single cell, it will look in that cell only.

When applied to an IOAKAddIn object, the method will display a dialog box if no arrays are detected, just as the equivalent OAK user-interface command does.

The OAK method finds all the arrays in the selection.  The Goto | Special | Current array method built in to Excel can only find one array at a time.