arrays - Matrix dynamic sizing with ReDim Preserve -

arrays - Matrix dynamic sizing with ReDim Preserve -

please, give @ next vba subroutine:

sub mysub() dim integer dim j integer dim myarray() double = 1 10 j = 1 5 redim preserve myarray(1 i, 1 j) myarray(i, j) = + j next j next end sub

this little illustration intended declare 2-dimensional array , dinamically resize via redim preserve: @ end of loop should homecoming 2-dimensional array each element sum of row , column indexes.

nevertheless, line of code returns error due subscript out of range:

redim preserve myarray(1 i, 1 j)

do need redim array before using redim preserve? doing that, issue still there.

arrays vba