Array variables using VBA in Microsoft Excel In these cases the size of the array variable need to be increased as necessary. When you use a ReDim-statement to change the array variable size, the variable contents is also erased. with dynamiquetableau