Runtime Error 1004 - Using VLOOKUP in VBA (COMPLETED)

[ReggaeYT]

Running a very basic test code to try out on a large amount of data, but having trouble, getting the "1004" error.

Sub HugeSort()
Dim c As Integer


'LOOPS THROUGH ALL ROWS
For c = 2 To 10

If IsEmpty(ActiveSheet.Cells(c, 1)) = False Then
ActiveSheet.Cells(c, 2) = Application.WorksheetFunction.VLookup(ActiveSheet.Cells(c, 1), Sheets("HALB").Range("A:B"), 2, 0)
End If
Next c


End Sub


Brief explanation: I've created a helper column (column 1) in 2 spreadsheets, and am now trying to VLOOKUP to transfer the data over from 1 to the other. Ran through 10000 lines and had no "1004" error in generating those helper numbers, but as soon as the VLOOKUP component was added, I can't get past this error. Thanks in advance for any help!

 

[ReggaeYT]

Re: Runtime Error 1004 - Using VLOOKUP in VBA

One other note: sometimes the error is "Unable to get the VLookup property of the WorksheetFunction class"