Ken,

I tried the code below and got an error stating that "no cells were found".
I forgot to mention that the formula and the precedent cells are on different
sheets of the spreadsheet.

Can you suggest an amendment to your code below that may help?

Brendan

"Ken Johnson" wrote:


Hi Brendan,

If the formula is in A1, Range("A1").Precedents.Address returns the
address of the precedents.

Ken Johnson