what is array size limit in VBA?

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
Dealing with unknown array sizes 7
Building a FormulaArray using VBA - Size Limit? 1
How to Populate an Array with a Discontiguous Values 5
Array Memory Size 7
Finding the maximum in an array of strings (Excel VBA) 6
Filling an Array Quickly 4
Filling an Array Quickly 13

Top