Redim array - out of range

Dear all,

I know that problem is obvious but now for me I have darkness in my mind. I try to load data from excel cells to variant array. Data is in columns A and B. My code:

Please Login or Register  to view this content.

And unfortunately I get error 'Subscription out of range'

You can only alter the outer dimension of the array when using ReDim Preserve

Direct from help file on ReDim

If you use the Preserve keyword, you can resize only the last array dimension and you can't change the number of dimensions at all. For example, if your array has only one dimension, you can resize that dimension because it is the last and only dimension. However, if your array has two or more dimensions, you can change the size of only the last dimension and still preserve the contents of the array. The following example shows how you can increase the size of the last dimension of a dynamic array without erasing any existing data contained in the array.

If you locate the last row you can use this instead

Please Login or Register  to view this content.

Andy Pope, thanks for explanation. I know this is the fastest way to load data to array and I use it always. But this case was for just practise.
Reputation point for you ;-)