VLookup

F

fabalicious

Can anyone tell me what's wrong with this expression?


ActiveCell.FormulaR1C1 = VLookup("G-Factor:", R1C1:R100C6, 6, False)

There seems to be a problem with the lookup range ( R1C1:R100C6)
probably the syntax. The string "G-Factor:" is within the lookup rang
and correct, there's a value on the same row in column 6 and I reall
can't see what else could cause failure....

Thanks a lo
 
R

Rob Bovey

This works for me:

ActiveCell.FormulaR1C1 = "=VLookup(""G-Factor:"", R1C1:R100C6, 6, False)"

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
B

Bob Phillips

Try this

ActiveCell.FormulaR1C1 = "=VLookup(""G-Factor:"", R1C1:R100C6, 6, False)"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top