Precedents Property

Applies To

Range Object.

Description

Accessor. Returns a Range object that represents all of the precedents of a cell. This may be a multiple selection (a union of Range objects) if there is more than one precedent. Read-only.

See Also

Dependents Property, DirectDependents Property, DirectPrecedents Property, ShowPrecedents Method.

Example

This example selects the precedents of cell A1 on Sheet1.


Worksheets("Sheet1").Activate
Range("A1").Precedents.Select