The exact limit that I'm referring to has to do with the formulaArray
function and is referred to by Microsoft he

http://support.microsoft.com/default...b;en-us;213181

The article made it seem like the issue was because VBA is storing the
formulas as strings. I'm sorry if I mispoke, but the issue still remains.
Why is there a character limit anywhere for anything?

"Peter T" wrote:

For the benefit of novices who might stumble on this thread, VBA does NOT
have a string length limit of 255.

In Excel there are string length limitations ranging from 255 to 32K
depending on what you are using or doing. These limits are not directly
related to VBA.

Not sure what the limit is in VBA, several million at least (for what
purpose) and possibly only limited by resources.

Regards,
Peter T

"Brett" wrote in message
...
This bug, which is well reported and even acknowledged my MS, has no
business
existing in the year 2006. Is there any work-around or patch available?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...id=5ca71f0f-32
52-4bca-b62d-ae2e9ccce263&dg=microsoft.public.excel.programming