Hello,

I am working with multidimensional arrays in excel
Is it any way I can apply the Redim function to them

For example I have an array ReplacementSchedule(,6)
I know the number of columns but I learn dynamically the number of rows

Ideally I would have liked to be able to say ReDim(ReplacementSchedule(NumRows,6))
However that does not work

Any ideas of how to install dynamic multidimensional arrays in excel?

Regards
Dora