vba - How to erase a multidimensional variant array holding objects and numbers -
i have following array want erase, or @ least clear:
dim arrfiles() variant
the array has 2 columns, lngindex , objfile.
i remember reading somewhere erase works in conditions. erase work on type? also, what's best way amount of memory used array?
thanks
dim arrfiles() variant
indicates dynamic array it's not declared dimensions erase
free memory using, e.g. attempting retrieve dimensions error.
as size, array of variant
each number 16 bytes , each string 22 bytes + lenb(thestring)
if concerned size, don't use variants; mix strong types in array structure use array of user defined type allow typearray(i).index / .file
Comments
Post a Comment