Precedents Property [Excel 2003 VBA Language Reference]
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.
Example
This example selects the precedents of cell A1 on Sheet1.
Worksheets("Sheet1").Activate
Range("A1").Precedents.Select
Applies to | Range Collection
See Also | Dependents Property | DirectDependents Property | DirectPrecedents Property | ShowPrecedents Method