Complicated Formula Precedents
Posted by Duncan on December 05, 2001 4:25 AM
I have a complicated formula
Where the Named Ranges Data.Reference and Data.Table are in another worksheet.
I think the formula points to the correct cell but am not sure.
What I would like is to be able to ask excel what cell it believes this formula points to.
Normal Precendents route does not work as it just shows what the constituent cells that make up the formula are and not what the final cell references is.
Can anyone help?!