The two workbooks are "PFA.xlsm", which holds the macro, and "Weekly Reports.xls", which holds the data. Both workbooks are open and stored on the I drive.
The macro is run on "Weekly Reports" to lookup a number and return a name.
The macro is:
' RefLookUp Macro
Range("A2:A" & Cells(65336, "B").End(xlUp).Row).Select
Selection.Formula = "=VLOOKUP(G2,'[I:\WHSE\BDG
After running the macro #N/A is returned and the value in Cell A2 is: