J
jacobk
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.
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.