NitinChaswal
New Member
- Joined
- Feb 4, 2016
- Messages
- 2
Hi Forum
Need help. Sometimes a particular worksheet needs to be deleted from the workbook when it no longer is needed. I got tired of manually checking out all the references that sheet has from other worksheets and also which sheets are referring to the current sheet so I can remove those references & delete the sheet to without irritating #REF errors all over my financial model. Specifically 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.
Can anyone help me with the Macro ?
One macro or two macros can do the job I suppose.
Need help. Sometimes a particular worksheet needs to be deleted from the workbook when it no longer is needed. I got tired of manually checking out all the references that sheet has from other worksheets and also which sheets are referring to the current sheet so I can remove those references & delete the sheet to without irritating #REF errors all over my financial model. Specifically 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.
Can anyone help me with the Macro ?
One macro or two macros can do the job I suppose.