Lookuprng error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Set LookupRng1 = Workbooks("vendor1.xls").Names("").RefersToRange

I need b96:c124 ans the range for the lookup and this error out. What needs
to be between the "". ??????

Please advise
 
Name the range b96:c124 on the worksheet as say "namedrng1" then

Set LookupRng1 = Workbooks("vendor1.xls").Names("namedrng1").RefersToRange

Regards,
Stefi

„Kip†ezt írta:
 
You must log in or register to reply here.

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 9
For Next does not find dates? 3
What is wrong with this code?!? 1
setting ranges and vlookup in custom functions 3
Problem with code - Help needed please 3
Multiple lookup? 9
Error 1004 in WorksheetFunction.VLookup 4
Button programming Run-time error '1004' with range 2

Back
Top