Macro Sheets Only
Equivalent to choosing the Go To command from the Edit menu and then selecting the Special button. Use SELECT.SPECIAL to select groups of similar cells in one of a variety of categories.
Syntax
SELECT.SPECIAL(type_num, value_type, levels)
SELECT.SPECIAL?(type_num, value_type, levels)
Type_num is a number from 1 to 13 corresponding to options in the Select Special dialog box and describes what to select.
Type_num Description
1 Notes
2 Constants
3 Formulas
4 Blanks
5 Current region
6 Current array
7 Row differences
8 Column differences
9 Precedents
10 Dependents
11 Last cell
12 Visible cells only (outlining)
13 All objects
Value_type is a number specifying which types of constants or formulas you want to select. Value_type is available only when type_num is 2 or 3.
Value_type Selects
1 Numbers
2 Text
4 Logical values
16 Error values
These values can be added to select more than one type. The default for value_type is 23, which select all value types.
Levels is a number specifying how precedents and dependents are selected. Levels is available only when type_num is 9 or 10. The default is 1.
Levels Selects
1 Direct only
2 All levels
Related Function
List of Command-Equivalent Functions