| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering Formula using Array
Hi,
I am trying to enter various formula into a range using the array function, as follows MyArray = Worksheets("Months").Range("MonthFormulaArray") MyArray = Array("=VLOOKUP(R2C,OHLCTable,3,FALSE)", "=VLOOKUP(R2C[-1],OHLCTable,4,FALSE)") I don't get any errors, but I also don't get my formula in the "MonthFormulaArray" range, which is a continuous range of cells all on the same row ie B5:C5. The actual range I am trying to fill is 48 cells. What am I doing wrong? Thanks in advance. Richard |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Entering Formula using Array
sorry, I've sorted it now
"Richard" wrote: Hi, I am trying to enter various formula into a range using the array function, as follows MyArray = Worksheets("Months").Range("MonthFormulaArray") MyArray = Array("=VLOOKUP(R2C,OHLCTable,3,FALSE)", "=VLOOKUP(R2C[-1],OHLCTable,4,FALSE)") I don't get any errors, but I also don't get my formula in the "MonthFormulaArray" range, which is a continuous range of cells all on the same row ie B5:C5. The actual range I am trying to fill is 48 cells. What am I doing wrong? Thanks in advance. Richard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering an array formula | Excel Worksheet Functions | |||
| entering formula in a numeric array | Excel Discussion (Misc queries) | |||
| entering as an array | Excel Discussion (Misc queries) | |||
| Entering Array Formula | Excel Programming | |||
| Programatically Entering an Array Formula | Excel Programming | |||
Linear Mode
