xlSpecialCellsValue

Specifies cells with a particular type of value to include in the result.

xlErrors16
xlLogical4
xlNumbers1
xlTextValues2

xlErrors
16
xlLogical
4
xlNumbers
1
xlTextValues
2

REMARKS
* The xlErrors will find the following error types: #CALC!, #DIV/0, #FIELD!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #SPILL!, #VALUE!.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top