Find below the list of Excel cell types as per XlCellType enumeration. A cell type is required when using SpecialCells, a method of the Range object used to target a specific type of cell.
|
Name |
Value |
Description |
|
xlCellTypeAllFormatConditions |
-4172 |
Cells
of any format. |
|
xlCellTypeAllValidation |
-4174 |
Cells
having validation criteria. |
|
xlCellTypeBlanks |
4 |
Empty
cells. |
|
xlCellTypeComments |
-4144 |
Cells
containing notes. |
|
xlCellTypeConstants |
2 |
Cells
containing constants. |
|
xlCellTypeFormulas |
-4123 |
Cells
containing formulas. |
|
xlCellTypeLastCell |
11 |
The
last cell in the used range. |
|
xlCellTypeSameFormatConditions |
-4173 |
Cells
having the same format. |
|
xlCellTypeSameValidation |
-4175 |
Cells
having the same validation criteria. |
|
xlCellTypeVisible |
12 |
All
visible cells. |
SpecialCells accepts a second parameter when the cell type is either xlCellTypeConstants or xlCellTypeFormulas, to further specify the types of cells to include in the result as per XlSpecialCellsValue enumeration.
|
Name |
Value |
Description |
|
xlErrors |
16 |
Cells
with errors. |
|
xlLogical |
4 |
Cells
with logical values. |
|
xlNumbers |
1 |
Cells
with numeric values. |
|
xlTextValues |
2 |
Cells
with text. |
No comments:
Post a Comment