Consulting

Results 1 to 4 of 4

Thread: Finding VBA and Function code

  1. #1
    VBAX Mentor
    Joined
    Nov 2008
    Posts
    305
    Location

    Finding VBA and Function code

    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.

  2. #2
    Open the Formula auditing toolbar and use the buttons trace dependents and trace precedents. That does not do VBA though.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  3. #3
    VBAX Tutor nst1107's Avatar
    Joined
    Nov 2008
    Location
    Monticello
    Posts
    245
    Location
    Open the VBE and use the Find command to look for that cell's address in the code.

  4. #4
    VBAX Expert
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    572
    Location
    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").
    I was not told it was impossible, so i did it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •