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?
Bookmarks