Partager via


XlCellType Enumeration

Specifies the type of cells.

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.