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.