View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default clearing an array

yes, redim would work for you


"NDBC" wrote:

null is fine. I just want to make sure the values that were stored last time
are gone.

I tried
count()=null
as well and that didn't work.


Should I use
redim count (1 to 5)



"Patrick Molloy" wrote:

its a variant, so when clear the values are null

Dim a() As Long ' or Double
ReDim a(1 To 10, 1 To 5)

now all values are 0

"NDBC" wrote:

If I have the array rider(5) as variant, how can I reset each of the array
variables to 0 without doing a loop 5 times.

count()=0 and
count().clear

do not work.

thanks