AddIn with Tables

  • Thread starter Thread starter Curare
  • Start date Start date
C

Curare

I am creating an AddIn that does a vlookup in one of the worksheets use
to created the add-in. Can this method work? Why I ask is because
get a compile error when I do this. Below is my vlookup coding I us
in the immediate window:

?application.vlookup(32,Tbles!A5:G130,2,0
 
Try adding the workbook name

??Application.Evaluate("VLOOKUP(32,'[myAddin.xla]Tbles'!A5:G130,2,0)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top