Declare Array Vba Access

So create an array (here of length 1): then its VBA type is 8197 - an array of type double, Excel recognizes it as array and it always has at least 1 element. Sub tstType_createArray() ' check the return type for a created array of length n=2 Debug.Print "---" Debug.Print VarType(createArray(1)) ' 8197 = array of type double Debug.Print IsArray(createArray(1)) ' true Debug.Print createArray(1 ... ................
................