Does filling part of an array from a range re-dimension the array?

**barryleajo** · 08-04-2011, 09:29 AM

Hi Everyone
I want to create an array with "spare" space to fill later based on some tests.
The example test code snippet below seems to suggest that filling part of the 'large' array from a range redimensions it down to the size of the range?
Is this the case and do I therefore need to ReDim again .. and again ...?

Please Login or Register  to view this content.

**mikerickson** · 08-04-2011, 09:48 AM

This line

Please Login or Register  to view this content.

assigns the variable myarray to the array of values in A1:B9. Nowhere does it specify "part of the array" or "starting at 1,1". After executing that line, myarray is a 9 X 2 array.

To partialy fill an array, you could use something like this

Please Login or Register  to view this content.

Alternatly, you could fill the array with the small data set and then expand the last index to your needs.

Please Login or Register  to view this content.

**solnajeff** · 08-04-2011, 09:52 AM

Hi

You can see the effect in the locals window if you step through the macro. As you are making the array equal to the range you are to all intents and purposes redimensioning the array.

Why not simply loop through the data to populate the parts of the array you need, as you are writing to an array it is very fast and takes a fraction of a second.

Regards

Jeff

**watersev** · 08-04-2011, 09:59 AM

hi, barryleajo, you can either take "A1:E9" into the array and fill 3,4,5 columns with new data or create a separate array with the same number of rows and 3 columns.