ExcelBanter - Entering Formula using Array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Entering Formula using Array (https://www.excelbanter.com/excel-programming/413889-entering-formula-using-array.html)

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

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