|
-
Oct 4th, 2000, 03:51 AM
#1
Thread Starter
New Member
I am currently outputting arrays of data to Excel, this all worked fine when outputting an array of size 12*381 (4572 elements), but fails when the arrays size is upped to 18 * 381 (6858 elements). Does anyone know what the output limit to Excel is?
{I have tried MSDN for several hours but drawn a total blank on the limit}.
Details:
VB Code:
.Range([Start Cell], [End Cell]).Value = ARRAY
Where ARRAY is an array exactly matching the Excel range in size. (This has been checked).
Software Versions:
Visual Basic 5 (SP2)
Excel 7.0a
Thanks for any help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|