One way would be to bring the formula in as a string and parse it to find the
precedents. Since programming a compiler for Excel is non-trivial, I would
consider searching the Internet for existing code.
--
Gary''s Student - gsnu200852


"FARAZ QURESHI" wrote:

The following macro selects precedents only if on the current sheet.

Sub Macro1()
ActiveCell.Precedents.Select
End Sub

If the cell contains reference to some other sheet in the same book the
error 1004 stating "No Cells Found" pops up.

Any suggestion?