Apparently you index is dimensioned as Integer. Dimension it as Long

--
Regards,
Tom Ogilvy


"Tony" wrote in message
...
I'm running Excel 2003 in Windows XP. I have 256MB Ram on my PC. I
needed
to create a 1 dimensional array using VBA macro programming with more than
32768 array elements. When I try to read more than 32768 data points I
get
an overflow error. I'm very surprised about this apparent limt as I
understood that Excel 2003 VBA array sizes were only limited by available
memory. Can you give me a definitive answer to the question: what is the
array size limit in Excel 2003 VBA? I should add that I'm using a dynamic
array when I'm reading in the data i.e. I redimension the array to add the
new data point each time. I would be very grateful if you can give me
some
advice.