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 ?
Have you checked Names in the workbook?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
That sounds like a message from some code. Do a searching thorugh the VBA of that workbook for the string 'Cannot find ' say.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
That was it ! It was a name set to automatically open each time the sheet was opened. I deleted and the message went away.
Thanks so much for your help.
Posting Permissions
Reply With Quote
