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 |
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 |