While Playing around I managed to stumble across a way to create an abnormally large 2D array with the Long variable type.

My target was a 2D array with 1,000,000,000,000,000,000 elements, But that wasn't quite possible with this method.
I did however manage to achieve a close 100,000,000,000,000,000 elements.

I haven't coded reading/writing to the array, but this should give you an idea of how I plan on doing it.

Main form:
Code:
Private myvar(100000000) As New Class1
Class module:
Code:
Private LargArray(1000000000) As Long
This should give me a possible array size of 100,000,000 x 1,000,000,000 , where as a normal long array can only be 10,000 x 10,000 in size.


Opinions?
Dose anyone foresee any possible problems with this method?