xlCellType

Specifies the type of cells.

xlCellTypeAllFormatConditionsAny type of Cells (-4172)
xlCellTypeAllValidationCells with Validation Criteria (-4174)
xlCellTypeBlanksBlank Cells (4)
xlCellTypeCommentsCells with Comments (-4144)
xlCellTypeConstantsCells with Constants (Non-Formula & Non-Blank) (2)
xlCellTypeFormulasCells with Formulas (beginning with a =) (-4123)
xlCellTypeLastCellGet Last Cell in the UsedRange (11)
xlCellTypeSameFormatConditionsCells with Common Format Conditions (-4173)
xlCellTypeSameValidationCells with Common Validation Criteria (-4175)
xlCellTypeVisibleAll Visible Cells (12)

xlCellTypeAllFormatConditions
Any type of Cells (-4172)
xlCellTypeAllValidation
Cells with Validation Criteria (-4174)
xlCellTypeBlanks
Blank Cells (4)
xlCellTypeComments
Cells with Comments (-4144)
xlCellTypeConstants
Cells with Constants (Non-Formula & Non-Blank) (2)
xlCellTypeFormulas
Cells with Formulas (beginning with a =) (-4123)
xlCellTypeLastCell
Get Last Cell in the UsedRange (11)
xlCellTypeSameFormatConditions
Cells with Common Format Conditions (-4173)
xlCellTypeSameValidation
Cells with Common Validation Criteria (-4175)
xlCellTypeVisible
All Visible Cells (12)


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