Help with VBA Code for Performing Vlookups Across Two Workbooks

I have written a code that works to perform vlookups across two workbooks I tested the code and I know it works if I remove the lines "Do Until IsEmpty(lookFor)" and "Loop" for performing a Vlookup for Cell B3, however I would like the code to be performed down the whole column. So my first question is am I using the Loop function correctly in the correct spot, if not how should I be using it? If I am using the Loop function correctly then how can I make this code more efficient, is there a better code for what I am trying to do? Every time I try to run my code excel crashes so I don't know if the code is just wrong or if its just too taxing on the program. Any help would be greatly appreciated!! :D

Please Login or Register  to view this content.

Ad 1. 'book2NamePath'

If 'ThisWorkbook' is in e.g. "C:\Temp" then 'ThisWorkbook.Path' = "C:\Temp", without "\" at the end,

then if "book2NamePath = ThisWorkbook.Path & "C:\Users\212549241\Documents\Projects\BulletTrain Austin" & book2Name", then we have mishmash:

"C:\TempC:\Users\212549241\Documents\Projects\BulletTrain Austin2017-10_Report 02 Bullet Train - 11-13a - new Saides - Lucio Ref 000000 - Rio (2).xlsm"

and additionally between 'BulletTrain Austin" and 'book2Name' there is missing next "\".


Ad 2. 'Workbooks.Open (book2NamePath)'

Not 'Workbooks.Open (book2NamePath)' but 'Workbooks.Open book2NamePath' or Workbooks.Open Filename:=book2NamePath, without parentheses.
With parentheses if is object assigning 'Set wrkb=' ==> Set wrkb = Workbooks.Open(book2NamePath)


And then ... there is ... something ... something incomprehensible ... ... sorry ...

Thanks for your response! But, as I said above that part of my code worked just fine for me. While continuing to research how to fix it I can tell that where my code went wrong is the loop, however I can't figure out how to fix the loop so it just reruns the vlookup for every cell down my column. Any help you could give related to fixing the loop would be awesome!! I am still really new to VBA and I don't really have a proper grasp on how to use loops.