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

Popular posts from this blog

how to proxy from https to http with lighttpd -

android - Automated my builds -

python - Flask migration error -