Declare an array with variable size

I need to create an array with a variable as it size

For instance:

Dim nSize as Integer

nSize = 4

Dim nArray(nSize) as Integer

But this doesn't work, I get an error: "Constant expression required"

Is there anyway that I can do this?

See the ReDim statement. And you should always specify both upper and lower bounds of arrays as a matter of good practice.

Hi gtmelony,

The following works for me:

Dim nSize As Integer, nArray()
nSize = 4
ReDim nArray(nSize)