Printable View
I'm sat looking at a worksheet someone else has created, and am wondering how/if it is possible to trace a cell.
What I mean by this is if for example I have a cell with a number in it, if I activate that cell, is there something I can do to see if that cell is linked to any formula?
Is there a similar function to see if it is linked with some vba code?
Cheers, yer ponderer.
Open the Formula auditing toolbar and use the buttons trace dependents and trace precedents. That does not do VBA though.
Open the VBE and use the Find command to look for that cell's address in the code.
Thats what i would do, remember that the cell in question could also be referenced as Cells(1,1) as well as Range("A1").Quote:
Open the VBE and use the Find command to look for that cell's address in the code.