VBA syntax - trying to input a vlookup into a cell

[Ron]

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

 

[Niek Otten]

Hi Ron,

Leave out the R1C1 before the equals sign