Loading array with string constant

[polarisking]

I'm trying to load a 6 element array with 6 defined string constants

The "arr =" statement is failing on "Syntax Error". Any ideas?

Dim arr  As Variant
  
Const varA  As String = "A"
Const varB  As String = "B"
Const varC  As String = "C"
Const varD  As String = "D"
Const varE  As String = "E"
Const varF  As String = "F"
 
arr = (varA,varB,varC,varD,varE,varF)

 

[NARAYANK991]

Hi ,

Try this :

arr = Array(varA, varB, varC, varD, varE, varF)

You can access individual elements of the array by arr(0) through arr(5).

Narayan

 

[polarisking]

Once again, you've delivered the solution. Thank you so much.

Note: I fully understand the 0 offset, but for ease of understanding for those coming after me who might have to debug or amend the macro, I always insert Option Base 1 so the array begins at 1.