Entering Formula using Array

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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