Dear Friends,

I want to call VLOOKUP from a macro as follows

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(name1,'[file2]sheet2'!name2:name3,5,0)"

where

name1 - is the reference name of the values in file 1 (active)
file2 - is the variable that contains the name of the file I want t
get the values
sheet2 - is the variable that contains the name of the sheet of file2
name2:name3 - is the table of [file2]sheet2 where name2, name3 ar
declared reference names

What is the correct way to call this function?

Thanks,
G

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