VLookUp Function

A

Ayo

I am get this error message:
"Unable to get the VLookup property of the WorksheetFunction class"
when the code gets to the Application.WorksheetFunction line below. I
sense there is something wrong but I can't put my finger on it.
Any ideas?
Thanks

Set smlWS = Worksheets("SAP Materials List")
smllastRow = smlWS.Range("B65536").End(xlUp).Row
Set rngsml = smlWS.Range("B2:C" & smllastRow)

Application.WorksheetFunction.VLookup(dbec.Offset(0, 3).Value, rngsml, 2,
False) & missingSAPlines
 
J

Jacob Skaria

Please try this.

Suppose you have data in A1:B2.

ColA ColB
1 One
2 Two

In immediate window try this

Msgbox
Application.WorksheetFunction.VLookup(Range("A1"),Range("A1:B2"),2,False)
 
J

Jacob Skaria

You need to remove missingSAPlines from the below code...

Application.WorksheetFunction.VLookup(dbec.Offset(0, 3).Value, rngsml,
2,False) & missingSAPlines

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top