Dynamic arrays

Hello,

Does VBA allow to use dynamic arrays? I've got a problem with redimensioning.

'Declare an array in general declaraions
Dim ShityArray (1,1) as String

'Then i try to redimension it in the cmdButton_click sub
Dim a As Integer
Dim b As Integer
a = 10
b = 10
ReDim Preserve ShityArray (a,b) As String

Result: VBA says "Compile error: Array already dimensioned"

Besides, i need to calculate "a" and "b" first, but VBA swears that dimesion should be declared by a constant.
Is it posible to declare dimensions with a variable? Or capture the value for constant from a textbox?

Hi try this

Please Login or Register  to view this content.

BTW, there is no point in preserving an empty array.