Create array of varying length?

[mae0429]

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

 

[pgc01]

Hi Matt

Try:

Dim dVar() As Double
 
ReDim dVar(3 To LastRow, 7 To 12)

 

[mae0429]

Wonderful! Thank you!

 

[Richard Schollar]

Hi

FYI you can skip the Dim statement altogether and just go with the Redim when you want to declare the array in code:

Dim LastRow As Long
LastRow = 100
'...

ReDim dVar(3 To LastRow, 7 To 12) As Double</pre>