Entering Formula using Array

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
CSE with function returning an array? 2
Cell values to an array, then array transpose to another workbook 8
Convert list to UPPER, lower & Proper cases. 21
Macro for Multiple Worksheets 6
Compile Error:Expected Array 2
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
deleting range with array formulas 1

Top