Range.SpecialCells method Archives

Learn

Excel Macro: Delete Duplicate Entries in a Range

The following example shows how to take a range of data in column A and delete duplicate entries. Delete Duplicate Entries in […]

Learn

Go To Special with VBA

You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.

Range.Dependents property Range.DirectDependents property Range.DirectPrecedents property Range.Precedents property Range.ColumnDifferences method Range.RowDifferences method XlCellType enumeration Range.SpecialCells method Range.CurrentRegion property

Docs

Range.SpecialCells method

Returns a Range object that represents all the cells that match the specified type and value. Syntax expression.SpecialCells (Type, Value) expression A […]

Range.SpecialCells method