Hi,

I would like to list all the cells that use cell A1 ("use" means A1 is being referred to in a formula).
For instance, if cell B2 contains the formula "=A1*2", I would like to find that out somehow automatically.

Is there a function like "=ISUSED(A1)" that returns TRUE if A1 is being referred to elsewhere in the Excel sheet?

Can anyone help?

Thanks