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.
 

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

vlookup in VBA 3
Remove Identical words 0
Timescalevalue update gives error 1101 0
Word macro that can call cells out of Excel for a find and replace 0
Word VBA Copy Heading and Content 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA for Dependents shortcut menu 0
Adding a VLookup to an AutoComplete ComboBox 0

Top