Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

XlCellType Enumeration

Office 2007
Specifies the type of cells.
xlCellTypeAllFormatConditions-4172Cells of any format.
xlCellTypeAllValidation-4174Cells having validation criteria.
xlCellTypeBlanks4Empty cells.
xlCellTypeComments-4144Cells containing notes.
xlCellTypeConstants2Cells containing constants.
xlCellTypeFormulas-4123Cells containing formulas.
xlCellTypeLastCell11The last cell in the used range.
xlCellTypeSameFormatConditions-4173Cells having the same format.
xlCellTypeSameValidation-4175Cells having the same validation criteria.
xlCellTypeVisible12All visible cells.

Community Additions

© 2015 Microsoft