B
banavas
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
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