In Excel 2003 and in earlier versions of Excel, the VBA array is longer than 1,823 characters in length. In Excel 2007, the VBA array is longer than 8,203 characters in length. This problem may occur when one of the following conditions is true: This issue may occur if one or more of the cells in an array (range of cells) contain a character string that is set to contain more than 911 characters.ĭata may be truncated when you transfer array data to cells in an Excel worksheet You may receive a “Run-time error 1004? error message when you programmatically set a large array string to a range in Excel 2003 ![]() Just to point to a limitation of the array method: no element can have more than 911 characters, if it has the write stops at that point.
0 Comments
Leave a Reply. |