PDA

View Full Version : Cannot find #REF



FinEnergyMan
11-04-2008, 03:23 PM
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 ?

mdmackillop
11-04-2008, 03:53 PM
Have you checked Names in the workbook?

Bob Phillips
11-04-2008, 03:54 PM
That sounds like a message from some code. Do a searching thorugh the VBA of that workbook for the string 'Cannot find ' say.

FinEnergyMan
11-04-2008, 04:10 PM
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.