Select each workbook's project (inside that VBE)
Tools|References
look for a reference marked MISSING (with a check mark next to it).
If you have that situation, uncheck that reference and save that workbook.
Deb Pingel wrote:
While trying to do a Vlookup between 2 spreadsheets, I get an error
message that says
Microsoft Visual Basic
Can't find project ot library
Then when you click on OK, you are taken to a screen titles
References-VBA project.
The 2 spreadsheets are on the same drive and in the same folder. Any
ideals?
Thanks
--
Deb Pingel
------------------------------------------------------------------------
Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119
View this thread: http://www.excelforum.com/showthread...hreadid=572346
--
Dave Peterson