Matrix Dimension as variable/constant

[gonurvia]

Hello, I am trying to make a function which would use a matrix of (N ,2) dimensions. The function (incomplete) is as following:

Function APPROACH(P1 As Range, x1 As Double, y1 As Double) As Double
N = P1.Rows.Count
Dim A1(1 To 3, 1 To 3) As Double
Dim A2(1 To [B]N[/B], 1 To 2) As Double

I get an error message which tells me N must be a constant. N is already defined as P1.Rows.Count and I won't change so, is there a way to change N from variable to constant? Also, I read something about matrices having a 32 dimension limit, is this true?


Thanks for the help!

 

[VBA Geek]

Hello, in fact N is not a constant. To make your code work, you'd need to use REd<code><code>im A2(1 To [B]N[/B], 1 To 2) As Double , when you use redim you can introduce variables.
Considering the dimensions limit, usually it's never wise to use more than 3 dimensions so you'd never find yourself in the situation of having so many dimensions, if you do then the code is not optimal.

</code></code>

 

[gonurvia]

thanks mate, it worked!!