I have a bit of a conundrum here: I am going to have sets of data that will have different numbers of rows, and I store the last used row as "LastRow". I am writing a function that will enter the values of certain columns into an array.
Is it possible to pass the "LastRow" variable to a function as a Variant, and then create an array in a way such as this:
Dim myVar(3 To LastRow, 7 To 12) As Double
I know that the array must be of a constant value, but is there a way around this?
Thanks,
-Matt
Is it possible to pass the "LastRow" variable to a function as a Variant, and then create an array in a way such as this:
Dim myVar(3 To LastRow, 7 To 12) As Double
I know that the array must be of a constant value, but is there a way around this?
Thanks,
-Matt