LinkBack URL
About LinkBacks
Hi Forum
Need help. I want to write a macro which when run will show all the precedents to a worksheet. And similarly another macro to show all the dependents of the worksheets.
Can anyone help me out?
Regards
Nitin
Macro to show all Precedents & Dependents instantly
Hi Forum
Need help. I want to write a macro which when run will show all the precedents to a worksheet. And similarly another macro to show all the dependents of the worksheets.
Can anyone help me out?
Regards
Nitin
Hi,
You'll need to define what YOU mean by precedents and dependents for worksheets. Those terms are usually associated with cells not worksheets.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Yeah my bad. Okay to reword :-
I want to know:-
1.) Which all sheets in the workbook are referenced in the active sheet
2.) And which all sheets are picking up data (or have references) from active sheet.
One macro or two macros can do the job I suppose.
Something like this should work.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you Mike . Will this work for finding which all sheets are referencing the active sheet if i make few changes ? i.e. all the dependent cells outside the active sheet.
Can you tell me which variables to change for doing the same?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks