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)

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

?application.vlookup(32,Tbles!A5:G130,2,0)


---
Message posted from http://www.ExcelForum.com/