List of sheets referencing active sheet (dependent sheets)

  • Hi all,


    I recall seeing a macro that would show a messagebox with the names of all the sheets that are referencing (pulling data from) the current sheet. Does anybody have that macro and can share it? My search on google turned out nothing so far. Would appreciate your help.

  • Re: List of sheets referencing active sheet (dependent sheets)


    Nope - not seen that one...


    Rough and ready - assumes the active sheet when run is the one you want to check references for. Also only handles simple formulas, should be within your abilities to change that.



    It could be more optimised, but it's just something to start with.

  • Re: List of sheets referencing active sheet (dependent sheets)


    Here is a different approach. It will find dependent sheets where the dependancy is through Names.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!