Vlookup function

T

teresa

Hi All,

Am using the below to do a vlookup

Sub fact()

Range("b50").Select
Range("b50").Value = WorksheetFunction.VLookup("a50", "c39:d40", 2, [false])

End Sub

Am receiving:
Application-defined or object-defined area
 
M

Michelle

teresa:
This looks like it pertains to Excel. You might have better luck posting to
the Excel newsgroup. Apologies if I'm mistaken.
 
Top