Error in Array

[Rekhapramod]

Hi All!

I am getting the below error stating that
"The Array is fixed or temporarily locked" while using ReDim
Pls give me the solution.

Regards,
RekhaPramod

[manishbhalshankar]

Hi Rekha,

Can you provide the code?

[Rekhapramod]

I just gave

Dim a(5)
ReDim a(10)

Regards,
Rekha.K

[TurtleRock]

Hi,

To use ReDim statement you should create an array with no size.

Dim a(5)
This statement will create an fixed size array, so you can not use redim with this array.

Instead Use :

Code:

Dim a()    
ReDim a(10)
ReDim a(20)

Cheers
TurtleRock

[Rekhapramod]

---

Thanks its working fine now