Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't programmatically set a large array string to a range.
Hi in my Excel VBA code, I assign a 2D array to a range to display the data.
Sometimes the string contained in one of the array cells will exceed 911 characteres. Right now in Excel 2003 whenever the string length exceeds 911 characters it causes a run-time error. I found this knowledge base article: You may receive a "Run-time error 1004" error message when you programmatically set a large array string to a range in Excel 2003 (Article ID : 818808) about the issue but its work around of not having more than 911 characters is not acceptable in our case since we have to support more than 911 characters. Since the problem is known in Aug 2004, I was wondering if there has been a patch or update or something solution that would resolve the problem? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limitation on MID function? - very large string | Excel Worksheet Functions | |||
LARGE with text string | Excel Worksheet Functions | |||
How do I programmatically specify a range. | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
VBA - Convert my variable range array to single cell string | Excel Programming |