View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tenerife Alan Tenerife Alan is offline
external usenet poster
 
Posts: 4
Default <<<<excel and VB lookup

I am using Excel 2003 and Visual Basic 6.3

VLOOKUP works fine in a worksheet but I am having trouble when I try to
invoke it in VB.

My code is

head = VLookup(code, "\icodes", 2)

Where code is a VB variable and "\icodes" is a named range on a worksheet.

I get the error message Function not defined.
--
Tenerife Alan