I am trying to use the following code to get a list of all
the precedents of cell A1 on Sheet1:

Sub sbGetPrecedents()
Worksheets("Sheet1").Activate
MsgBox Range("A1").Precedents.Address
End Sub

It seems to create a list of all the precedents that are
on Sheet1, but it does not include the precedents that are
on other worksheets. Does anybody have a suggestion how I
can get these as well??? TIA