Hi Ron,

Leave out the R1C1 before the equals sign

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ron" wrote in message
...
Here's what I am inputting:
ActiveCell.FormulaR1C1 =
"=VLOOKUP($J$1,[TechSchedBL.xlsx]sheet1!$11:$17,2,FALSE)"

I'm sure there is some quotes he's going to need, but nothing works so
far.
It took me a while to figure this one out.

ActiveCell.Value = "=Text(I1,""dddd"")"

Any help would be appreciated.

Ron