View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jacobk jacobk is offline
external usenet poster
 
Posts: 2
Default 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.