How to start a dynamic array from 1 without using Option Base=1 at the top of the modul?

[Jamualson]

The best idea I could get is just leave it 0 based and start putting values into the array at 1. So it will be "like" a 1 based.

Is this a bad approach? If yes, what could be a solution for starting the dynamic array from 1, without using option base=1? Thank you very much

Sub Arr()

Dim MyArr() As String

ReDim MyArr(2)

'MyArr(0) = "0"
MyArr(1) = "1"
MyArr(2) = "2"

End Sub

 

[Domenic]

You can set the lower bound, in addition to the upper bound...

ReDim MyArr(1 to 2)

So now you have a two element array...

MyArr(1) = "1"
MyArr(2) = "2"

Hope this helps!

 

[Jamualson]

You can set the lower bound, in addition to the upper bound...

ReDim MyArr(1 to 2)

So now you have a two element array...

MyArr(1) = "1"
MyArr(2) = "2"

Hope this helps!

Legend, thank you very much