VBA syntax - trying to input a vlookup into a cell

  • Thread starter Thread starter Ron
  • Start date Start date
R

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup text in vba 3
Adding the IF function to a VLOOKUP function. 2
Excel VBA Vlookup 3
vlookup - how to put this into VBA 2
Excel VBA Macro for vlookups 3
Vlookup to insert num in mult. columns 8
VBA Code for Multiple VLOOKUPS 1
Text Box contents to cell comments 5

Back
Top