Introduction - Microsoft

If we wish to preserve the contents of the array however, we must include the Preserve keyword or else the contents will be lost, i.e. ReDim Preserve Company(3) (This can be repeated, e.g. ReDim Preserve Company(5).) When inputting data using an input box, an array size could be dynamically adjusted as more data is input. ................
................