Limit on array when using seriescollection.XValues and .Values met
What do you mean by size of arrays? If you mean the number of X or Y entries
you could have, that's definitely not true. If you mean the formula, of
course all Excel formulas can't have more than 256 characters.
"Pasi Husso" wrote:
Hi
I've been working around on this automated tool which gathers some data and
then is supposed to plot graph out of data. But the plotting part is really
giving me some headache. To be more specific runtime error 1004
It seems that somehow the size of arrays, to be excact the character count
of X and Y-values, implemented to the series is limited to (not sure, but my
educated guess would be) about 255-256 characters.
If possible, is there somebody who could prove me wrong (or right) so could
move on this matter. This is starting to feel like beating my head against
the wall.
Cheers
|