VBA 2-Dimensional Array Unable to Assign Values into Sheet

[timotito]

Hello, I'm working on a macro which uses a 2-D Variant array to assign some formulas onto an Excel sheet. Here's an MWE:

Dim aMatrix As Variant
ReDim aMatrix(1 To 15625, 1 To 30)

Dim I As Long
Dim J As Long

For I = 1 To 30
    For J = 1 To 15625
        aMatrix(J, I) = ...
    Next J
Next I

Worksheets("Example").Range("A1:AD15625").Values = aMatrix

After running this macro, I observe that the sheet isn't fully populated; after the 625th row, the sheet is empty. I initially thought it was a RAM issue, but after running this on different PCs and also using a module of VBA functions I found online (VBA Arrays) to attempt to do the assignment column-by-column, the sheet still appears to only populate up to the 625th row. Any ideas or help would be super helpful...cheers.

 

[jolivanes]

This filled range A1:AD15625 for me!

Sub AAAAA()
Dim aMatrix As Variant
ReDim aMatrix(1 To 15625, 1 To 30)
Dim I As Long
Dim J As Long
For I = 1 To 30
    For J = 1 To 15625
        aMatrix(J, I) = I & J
    Next J
Next I
Worksheets("Sheet2").Cells(1, 1).Resize(UBound(aMatrix, 1), UBound(aMatrix, 2)) = aMatrix
End Sub

BTW, what is an MWE?