I tried searching for this topic but was not able to find anything. When opening a workbook I am getting a prompt that says:"Cannot find #REF$B$1, which has been assigned to run each time [workbook name] is open.
I have disabled all the links and have searched all the worksheets for the broken reference but haven't found one. Is there a way to find the broken reference through VBA ?