Load Values To Array Using .CurrentRegion With Array Base 0

Hi,

I have random numbers in Cell A1:D3.

Using this code, I can store values to a 2-D array.

Please Login or Register  to view this content.

The problem here is, the Lbound of the Array starts with 1.

I would like to know which is the best way to get the same array, but the bounds to start from 0?

What I currently do is, make a similar array and redim it with the Bounds of the previous array subtracted by 1 and then load values to it from the 1st array.

Not sure if this is the most efficient approach.

Even if you set the option to 0, it will not make any difference, if you load a range in to an array, it always produces a two-dim, starting with 1.

Yes, I am aware of that..

This is just for the sake of knowledge that I am trying to understand.

I just want the same array with the base 0 and not 1. (I am now talking about the Option Base Statement, I am just trying to figure out if there is any other way)