Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FormulaArray problem | Excel Programming | |||
Using FormulaArray in VBA | Excel Programming | |||
FormulaArray | Excel Worksheet Functions | |||
FormulaArray..... HELP !!! | Excel Programming | |||
FormulaArray | Excel Programming |