Range.Precedents Property

Syntax

expression.Precedents

expression A variable that represents a Range object.

Example

This example selects the precedents of cell A1 on Sheet1.

Visual Basic for Applications
`Worksheets("Sheet1").Activate Range("A1").Precedents.Select`

Bring back a complete list of precedents for a named cell? Obtain a list of cell precedents? precedents Precedents Property Precedents? Return a range representing all precedents of a particular cell?

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

See also: