-
Solved: WorksheetFunction.Vlookup Different Workbook Reference
Error Message receiving:
'Unable to get the Vlookup property of the WorksheetFunction class'
Looking at the value in the activesheet, the table array argument reference is the workbook, sheet referenced in the function below.
[VBA]
For i = 4 To lrwsource
If Cells(i, 23).Value > 40 Then
Cells(i, 9).Value = WorksheetFunction.VLookup(Cells(i, 9), "[TGSItemRecordCreatorMaster.xls]ColorDB!$J$3:$K$198", 2, 0)
End If
Next i
[/VBA]
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules