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.