Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Geeske Bakker on Feb 01 In MS Office Category.

Vlookup in VBA

Question Answered By: Rosa Reynolds on Feb 01

It doesn't work because in
Selection.FormulaR1C1 = "=VLOOKUP(Cells(KeyStartRow, TitleCol),'Ref.
Tables'!C[4]:C[5],2,FALSE)"

You don't want KeyStartRow. You want the current row.

This Question has 4 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Vlookup in VBA Or get search suggestion and latest updates.

Tagged:vlookup in vba

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us