Clear contents of array

[osx99]

What is the best way to clear the contents of an array in VBA?

eg i have a constant 376 variables for upto 1 - 100 items spread across a number of days. the no. of items vary each day.

Say the code runs with 50 items for the first day then Datastor(49,376) is full of data, the following day if only 25 items are present then the remaining array after Datastor(25,376) contains data I don't need from the previous loop

Is there a quick way of clearing out the contents of the array stated below without a full cycle through setting everything to null?

Dim DataStor(100, 376) As Variant

 

[Bong]

erase Datastor

_________________
Bob Rashkin

 

[CautionMP]

osx99,
If it helps you can clear and change the dimensions in the same step.

[tt]ReDim DataStor(100, 376) As Variant[/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[strongm]

Only if Datastor was DIMmed as a dynamic array. You cannot redim a static array.

 

[CautionMP]

strongm,
Good point, I always forget that...

CMP