I want my multidimensional array to be dynamic, when I am trying to do that using reDim i am getting the error "This array is fixed or temporarily locked:refArr ", Following is my code:
max=10
dim refArr(10,2)
dim i
i=0
while not rs1.eof
max=max+1
redim refArr(max,2)
niftyChange=0
refArr(i,0)="niftyDate"
refArr(i,1)="temp"
i=i+1
rs1.movenext
wend
If you are going to ReDim it, you need to dim
it with no size initially:
dim refArr()
I think you actually want to use ReDim Preserve
, though, to keep the existing data.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With