You can use the Erase statement to clear a static array.

Sub a()
Dim MyArray(0) As String
MyArray(0) = "abc"
MsgBox MyArray(0)
Erase MyArray
MsgBox MyArray(0)
End Sub


--
Jim Rech
Excel MVP
"JJ" wrote in message
...
|I can load an array and then it to another sheet. What I
| would like to do is clear the array and then re-load it
| with different data and write it below the existing data
| on another sheet.
|
| How can I clear the array after writing it to the second
| sheet?
|
| Thanks