| title | Range.Precedents property (Excel) | |
|---|---|---|
| keywords | vbaxl10.chm144178 | |
| f1_keywords |
|
|
| api_name |
|
|
| ms.assetid | 3c00cfb4-1c12-668d-a952-89f9b1ef129f | |
| ms.date | 05/11/2019 | |
| ms.localizationpriority | medium |
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[!includeSupport and feedback]