|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 14th, 2009, 10:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
May 14th, 2009, 11:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
