Changing Array Size

When you want to declare array in VBA and change the array size
you can go like this.

Dim list1() as String

When you want to first use it, set the size:

Redim List1(10)

When you want to change size and lose the contents

Redim List1(20)

If you want to increase size and retain the contents

Redim Preserve List1(30)

Author
Kazi Masudul Alam