VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

When you are trying to understand an unfamiliar workbook or Excel model, it can immensely help knowing which tabs are feeding into the one you are currently viewing. This little macro will give you a message box indicating any outside worksheet references found in the cell formulas of the ActiveSheet. 

Read More