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/