Programming Excel with VBA and .NET

Name

range.SpecialCells(Type, [Value])

Synopsis

Returns a Range object representing cells of the specified type.

Argument	Settings
Type	xlCellTypeAllFormatConditions returns cells of any format; xlCellTypeAllValidation returns cells having validation criteria; xlCellTypeBlanks returns empty cells; xlCellTypeComments returns cells containing notes; xlCellTypeConstants returns cells containing constants; xlCellTypeFormulas returns cells containing formulas; xlCellTypeLastCell returns the last cell in the used range; xlCellTypeSameFormatConditions returns cells having the same format; xlCellTypeSameValidation returns cells having the same validation criteria; xlCellTypeVisible returns all visible cells.
Value	It Type is xlConstants or xlFormulas, xlNumbers returns cells containing numbers; xlTextValues returns cells containing text; xlLogical returns cells containing logical values; and xlErrors returns cells containing error values.