Thread: VBA syntax - trying to input a vlookup into a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
  
Posts: 250
Default 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

Reply With QuoteReply With Quote