Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
arrays
I write data into an array. later on in the macro, I
write the array to a spreadsheet. At this point, I want to clear the array. Is there an easy way to clear an array after you are done with it? Thanks for the help........ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
arrays
Erase MyArray
the behavior would depend on how you declared it. See vba help for details -- Regards, Tom Ogilvy "JT" wrote in message ... I write data into an array. later on in the macro, I write the array to a spreadsheet. At this point, I want to clear the array. Is there an easy way to clear an array after you are done with it? Thanks for the help........ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
arrays
Redim without the key word preserve wipes out the contents of an array... If
Tom's doesn't work for you. Depends how you created the array once again. HTH "JT" wrote: I write data into an array. later on in the macro, I write the array to a spreadsheet. At this point, I want to clear the array. Is there an easy way to clear an array after you are done with it? Thanks for the help........ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regarding the Arrays | Excel Discussion (Misc queries) | |||
Need help with arrays (I think) | Excel Worksheet Functions | |||
3D Arrays | Excel Worksheet Functions | |||
VBA arrays | Excel Programming | |||
Arrays | Excel Programming |