ExcelBanter - VBA syntax - trying to input a vlookup into a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA syntax - trying to input a vlookup into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/230887-vba-syntax-trying-input-vlookup-into-cell.html)

Ron

VBA syntax - trying to input a vlookup into a cell

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

VBA syntax - trying to input a vlookup into a cell

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

All times are GMT +1. The time now is 07:24 AM.