Special Cell List (Excel 97)

Topic

New Reply

Hello,

I was wondering if anyone had a list of the special cell types around.

e.g. SpecialCells(xlCellTypeBlanks)

Thanks!

Reply | Quote

Replies

From Help:

Syntax
expression.SpecialCells(Type, Value)
expression Required. An expression that returns a Range object.

Type Required Long. The cells to include. Can be one of the following XlCellType constants.

Constant Description
xlCellTypeNotes Cells containing notes
xlCellTypeConstants Cells containing constants
xlCellTypeFormulas Cells containing formulas
xlCellTypeBlanks Empty cells
xlCellTypeLastCell The last cell in the used range
xlCellTypeVisible All visible cells
Value Optional Variant. If Type is either xlCellTypeConstants or xlCellTypeFormulas, this argument is used to determine which types of cells to include in the result. These values can be added together to return more than one type. The default is to select all constants or formulas, no matter what the type. Can be one of the following XlSpecialCellsValues constants: xlErrors, xlLogical, xlNumbers, xlTextValues, xlAllFormatConditions, or xlSameFormatConditions.

Reply | Quote

Thank-you very much!

Reply | Quote

The following example will select all cells in the active worksheet that contain a formula which returns an error, such as #N/A, #DIV0! etc.

Cells.SpecialCells(xlFormulas, xlErrors).Select

Andrew C

Reply | Quote