For variable length Strings specifically....

The array item (index) uses 4 bytes, regardless of the size of the string. But that index is just a pointer to the actual string data. That string data can contain 0 to n bytes worth of characters. Therefore, setting a string to "" uses 6 bytes for the string. Setting it to vbNullString uses zero bytes for the string. Setting strings to vbNullString is better than ""