Empty an Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

Just wondering how to empty an array after it has values in it.

Thanks,

Brad
 
Erase MyArrayName

Note that if it was originally declared as a dynamic array, this erases all
memory used by the array, so you'll have to ReDim it before you use it.
 
I've known it for a while. I just always forget it when I need to use it!
<g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open File Dialog - Multiple file selection limited to 7 files? 1
Shape Arrays VBA 0
MultiDimensional Array Syntax 4
List of Table Names in DB 5
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Array Compartments 3
Excel Wildcard in Excel array formula 0
instr 2

Back
Top