Dynamic Array « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. Dynamic Array
1.Dynamic Arrays
2.Declaring and Working with Dynamic Arrays
3.Use ReDim to create dynamic array
4.Using a Dynamic Array
5.There's a potential problem when you try to resize the array:
6.A destroying the old values by using the Preserve keyword
7.Use the Preserve keyword to keep the values
8.Transpose() sub procedure is using a dynamic array that is re-dimensioned with two dimensions.