| Home |
| Search |
| Today's Posts |
|
#1
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace input cell data using Vlookup | Excel Worksheet Functions | |||
| Excel 2007 Vlookup Using New Table Syntax | Excel Worksheet Functions | |||
| Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
| Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
| Vlookup Syntax Error | New Users to Excel | |||
Linear Mode
