kavkazi
05-06-2010, 08:43 AM
Hello,
I am trying to do a vlookup on current worksheet compared to a range in another file.
I get a "Run Time Error 1004: Unable to get the vlookup property of the worksheet function class".
After some investigation, I found out that if there are some values that dont match up this could be a problem. In my case I will run into that situiation. But for testing purposes, I tried manipulating the data so that this doesnt happen. With no luck.
Here is my code:
Dim lastrow as Long
lastrow = Sheets("Master List").Range("A1").End(xlDown).Row
For i = 2 To lastrow
Sheets("Master List").Cells(i, "B").Value = Application.WorksheetFunction.VLookup(Sheets("Master List").Cells(i, "A"), "'T:\Operations+Technology\NOC\Abuse Emails\[Customer Data for Abuse Emails.xls]Report'!$E$4:$G$60000", 2, False)
Next i
Thanks in Advance
I am trying to do a vlookup on current worksheet compared to a range in another file.
I get a "Run Time Error 1004: Unable to get the vlookup property of the worksheet function class".
After some investigation, I found out that if there are some values that dont match up this could be a problem. In my case I will run into that situiation. But for testing purposes, I tried manipulating the data so that this doesnt happen. With no luck.
Here is my code:
Dim lastrow as Long
lastrow = Sheets("Master List").Range("A1").End(xlDown).Row
For i = 2 To lastrow
Sheets("Master List").Cells(i, "B").Value = Application.WorksheetFunction.VLookup(Sheets("Master List").Cells(i, "A"), "'T:\Operations+Technology\NOC\Abuse Emails\[Customer Data for Abuse Emails.xls]Report'!$E$4:$G$60000", 2, False)
Next i
Thanks in Advance