vba question
Posted: January 21st, 2016, 8:55 pm
by Beachcomber
This doesn't seem that hard, but I can't seem to do it.I want to dimension several matrix variables named, for example, matrix1, matrix2, matrix3, etc...That is Dim matrix1() as variant, etc.but the number of matrixi variables that i need varies and is an input. I have to believe there is a way to do this.Perhaps I am not being very clear. I am passed an M x N matrix. I know neither M nor N. Because of our upload protocol, I need to pass along N M x 1 matrices to another program. I am not sure how to set up an unknown amount of matrices. Beachcomber
vba question
Posted: January 22nd, 2016, 12:53 pm
by fulmerspot
QuoteOriginally posted by: BeachcomberThis doesn't seem that hard, but I can't seem to do it.I want to dimension several matrix variables named, for example, matrix1, matrix2, matrix3, etc...That is Dim matrix1() as variant, etc.but the number of matrixi variables that i need varies and is an input. I have to believe there is a way to do this.Perhaps I am not being very clear. I am passed an M x N matrix. I know neither M nor N. Because of our upload protocol, I need to pass along N M x 1 matrices to another program. I am not sure how to set up an unknown amount of matrices. BeachcomberCan you not just use the ReDim statement?Herr KartoffelKopf