Clear/Delete an Array

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

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

In article <ca6601c4391f$b1268e80$a401280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> 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
>

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

Thanks,
Raul
>-----Original Message-----
>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
>
>In article <ca6601c4391f$b1268e80$a401280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> 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,
"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

>-----Original Message-----
>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
>
>In article <ca6601c4391f$b1268e80$a401280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> 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,
"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

>-----Original Message-----
>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
>
>In article <ca6601c4391f$b1268e80$a401280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> 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
>>
>.
>

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

In article <ce2d01c43928$7b83d950$a301280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> 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
>
> >-----Original Message-----
> >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
> >
> >In article <ca6601c4391f$b1268e80$a401280a@phx.gbl>,
> >anonymous@discussions.microsoft.com says...
> >> 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
> >>
> >.
> >
>