Clear/Delete an Array

[Raul]

I populate an array in my code and after I'm through with
it I'd like to delete the array to free up some resources.
What is the proper procedure for clearing/deleting an
array in VBA?

Thanks,
Raul

 

[Tushar Mehta]

If you search XL 97 VBE help for 'clear' (w/o the quotes), one of the
options is 'clearing arrays' (w/o the quotes). If you search a more
recent version of the software (I tried 2003), It seems impossible to
find the Erase function, which is what you need. Sad commentary on the
state of the new help, eh?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

 

[Raul]

I'll try to track down a version of Excel 97.

Thanks,
Raul

 

[Raul]

Tushar,
"Erase array" was the key. I had been searching
for "clear array" and "delete array" in the MSDN library
to no avail. The following link was one the results when
I used "erase array"; it provided what I needed.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/script56/html/vsstmerase.asp

Thanks again,
Raul

 

[Raul]

Tushar,
"Erase array" was the key. I had been searching
for "clear array" and "delete array" in the MSDN library
to no avail. The following link was one the results when
I used "erase array"; it provided what I needed.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/script56/html/vsstmerase.asp

Thanks again,
Raul

 

[Tushar Mehta]

Why do you think I spelled 'Erase' with a capital letter? <grin>
Searching XL VBE help for 'erase' will also lead to the erase statement.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004