Hi I'm wondering if it's possible to highlight a cell and find out whether any other cells reference (ie pull the value from) that cell.
Thanks!
Rae
Hi I'm wondering if it's possible to highlight a cell and find out whether any other cells reference (ie pull the value from) that cell.
Thanks!
Rae
Select the cell
This will draw arrows to each cell that references the selected cell...
Formulas.Trace_Dependents
Does that help?
On the formula's Tab, there is "Trace Dependents" and "Trace Precedents" Dependents will show you will that cell value is used in other cell formulas. If the formula is on a different spreadsheet, you'll see a little spreadsheet icon. If you double click on the dotted line, it'll open the GoTo window with the specific references.
Is that what you were looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks