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