Clean Out Array 3

[UnsolvedCoding]

Hey all -

I have an array that is resizes itself and I want to reuse the array. There will be varying amounts of information being put into the array and I need to be sure that information cleans out so each time the array is re-used it starts over with no carry over from previous uses. Carry over would screw up my email message.

Example -

Use one holds the a b c d e f

Use two would use a b c

Use three would be a b c d e


How can I clear out all the old array information to re-use the array?

 

[jges]

Erase arrayName

http://msdn.microsoft.com/en-us/library/83zyeke9(v=VS.80).aspx

 

[judgeh59]

If I remember correctly...check out the erase command...

good luck

Be Alert, America needs more lerts

 

[mscallisto]

To jges

Your example shows a ReDim of a static array, I may be wrong but I thought you can only ReDim a dynamic array

http://msdn.microsoft.com/en-us/library/83zyeke9(v=VS.80).aspx

Dim threeDimArray(9, 9, 9), twoDimArray(9, 9) As Integer
Erase threeDimArray, twoDimArray
ReDim threeDimArray(4, 4, 9)

Sam

 

[UnsolvedCoding]

The Erase function wasn't taking and it took some tedious testing but the issue has been resolved. For some reason the cell count wasn't advancing as it should have which left one item in the array after the Erase.

Don't know why but its not happening now.

Thanks guys.