VBA Option Base 1 question

[antaeusguy]

Hi

I wish to clarify the purpose of Option Base 1.

I now want the array Country() to contain only 12 elements.

If I've declared Option Base 1, then the ReDim would start at 1 and ends at 12.

Option Base 1
Sub Example1()
    Dim Country() As String
    ReDim Country(12)
End Sub

If I did not declare Option Base 1, then I would need to specify the ReDim so that it would start at 1 and ends at 12.

Sub Example1()
    Dim Country() As String
    ReDim Country(1 To 12)
End Sub

I would like to know if declaring both Option Base 1 and also in the ReDim to be unnecessary... that I just need to declare only one would do.

Option Base 1
Sub Example1()
    Dim Country() As String
    ReDim Country(1 To 12)
End Sub

Thanks in advance!

 

[Leith Ross]

Hello antaeusguy,

The Option Base 1 statement will apply to all arrays delared in the module with that statement. Using either Dim or ReDim with the To statement will only change the base of that specific array.

Sincerely,
Leith Ross