FormulaArray limits?
 

Hello all,

I use the code of Ron de Bruin for copying a range from a closed Worksheet.
The function with FormulaArray works fine with the range A15:M2000, but I
need a range from A15:Y2000.
As soon as I get a greater column then M, an error 2004 is the result.
I know the limitation of 255 characters for the formula length, this isn't
the issue.
Excel 2003.
Any suggestions?
Or perhaps an other way to copy a great range of values from a closed
worksheet?

Thanks in advance for your time and help.

Jacob.

[SOLVED] FormulaArray limits?
 

Solution found!
There was something wrong in the target sheet.
After deleting all rows, it works again.

"jacobk" wrote:

Hello all,

I use the code of Ron de Bruin for copying a range from a closed Worksheet.
The function with FormulaArray works fine with the range A15:M2000, but I
need a range from A15:Y2000.
As soon as I get a greater column then M, an error 2004 is the result.
I know the limitation of 255 characters for the formula length, this isn't
the issue.
Excel 2003.
Any suggestions?
Or perhaps an other way to copy a great range of values from a closed
worksheet?

Thanks in advance for your time and help.

Jacob.