I'm trying to figure out how to populate a long array.
The lines commented out did not work.
I'm able to populate a long array one element at a time, but I can't figure out how to populate the whole array at once.
I've tried Split & Array, and neither seemed to work.

I also would like to refer to the index by hex numbers, that seems to be working.

Sub PopulateLongArray()
    'Const nArray(&H0 To &H9) as Long = (9, 8, 7, 6, 5, 4, 3, 2, 1, 0)
    Dim nArray(&H0 To &H9) As Long
    'nArray = Split("9, 8, 7, 6, 5, 4, 3, 2, 1, 0", ",")
    'nArray = Array(9, 8, 7, 6, 5, 4, 3, 2, 1, 0)
    nArray(&H0) = 9
    nArray(&H1) = 8
    nArray(&H2) = 7
    nArray(&H3) = 6
    nArray(&H4) = 5
    nArray(&H5) = 4
    nArray(&H6) = 3
    nArray(&H7) = 2
    nArray(&H8) = 1
    nArray(&H9) = 0
End Sub