PDA

View Full Version : Finding VBA and Function code



ukdane
01-14-2009, 03:58 AM
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.

Jan Karel Pieterse
01-14-2009, 04:18 AM
Open the Formula auditing toolbar and use the buttons trace dependents and trace precedents. That does not do VBA though.

nst1107
01-14-2009, 09:39 AM
Open the VBE and use the Find command to look for that cell's address in the code.

georgiboy
01-14-2009, 10:31 AM
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").