i would like to set the limit for an array that i'm creating to a value that is not a const,

Dim Ordered(sqlcol) As Integer

but it won't compile due to the fact that sqlcol is not a constant value, have do i get this to work, any help is much appreciated.

Piers