Mike,

Here's an example

ReDim aryMe(UBound(aryMe, 1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mike" wrote in message
...
This newsgroup has been a big help. Thanks. I have one
more question. I'm just beginning to use arrays.

I read one record in a spreadsheet, and if it meets
certain conditions, an array is populated. The array is
then written somewhere else.

We go to the next record and look for certain conditions.
If we find it, we need to populat the array again.
However, there may be fewer or more items in the array
each time.

How do I clear an array so that it is empty when i go to
the next record. thanks for the help