Range.Precedents Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

expression .Precedents

expression A variable that represents a Range object.

This example selects the precedents of cell A1 on Sheet1.

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

Concepts

Other resources

Show: