Is An Array Allocated? This page describes a VBA procedure you
can use to determine whether a dynamic array or an array in a
Variant has been allocated. There are two types of arrays:
static arrays, in which the dimensions of the array are set in
the Dim statement, and dynamic arrays, in which the array is
allocated and dimensioned with the ReDim statement. An array is
said to be allocated if it consumes memory, has valid lower and
upper bounds, and contains data (even if that data is the
default values for the data type of the array, such as empty
strings of an array of String type variables). A static array is
by definition always allocated. You can never resize,
reallocate, deallocate, or release the memory consumed by a
static array. With a dynamic array, however, you can resizse,
reallocate, deallocate, and release the memory of the array. (A
Varaint type variable that contains an array always contains a
dynamic array.) At times, you may need to test whether a dynamic
array has been allocated or whether