Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message during vlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message during vlookup
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message during vlookup
that worked, I had 2 missing references, and we also discovered some empty spaces after the numbers we were tryiong to match. Mystery SOLVED! -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |