Hi,
I get a "Subscript out of range" type error when I run this code. I assume there is something wrong with syntax (file path):
<font face=Courier New><SPAN style="color:#00007F">For</SPAN> i = Lastrow <SPAN style="color:#00007F">To</SPAN> 2 <SPAN style="color:#00007F">Step</SPAN> -1<br> Range("D" & i).Value = Application.VLookup(Range("C" & i).Value, Worksheets("\\tom\grp-vol1\Planning\Product availabilty\[Test VLookup.xls]Sheet1").Range("A1:B99"), 2, <SPAN style="color:#00007F">False</SPAN>)<br><SPAN style="color:#00007F">Next</SPAN> i</FONT>
Also, the file from which I want to retrieve a value is on a shared folder on the network. Do I need to first open the file for the VLookup to work or not?
Hopefully someone can help.
Thanks,
Plix
I get a "Subscript out of range" type error when I run this code. I assume there is something wrong with syntax (file path):
<font face=Courier New><SPAN style="color:#00007F">For</SPAN> i = Lastrow <SPAN style="color:#00007F">To</SPAN> 2 <SPAN style="color:#00007F">Step</SPAN> -1<br> Range("D" & i).Value = Application.VLookup(Range("C" & i).Value, Worksheets("\\tom\grp-vol1\Planning\Product availabilty\[Test VLookup.xls]Sheet1").Range("A1:B99"), 2, <SPAN style="color:#00007F">False</SPAN>)<br><SPAN style="color:#00007F">Next</SPAN> i</FONT>
Also, the file from which I want to retrieve a value is on a shared folder on the network. Do I need to first open the file for the VLookup to work or not?
Hopefully someone can help.
Thanks,
Plix