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

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

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 *


"fabalicious " wrote in message
...
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 range
and correct, there's a value on the same row in column 6 and I really
can't see what else could cause failure....

Thanks a lot


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

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)

"fabalicious " wrote in message
...
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 range
and correct, there's a value on the same row in column 6 and I really
can't see what else could cause failure....

Thanks a lot


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

...so it does for me

Cheers
fabalciou

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