Thread: earasing arrays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default earasing arrays

The code you show does not demonstrate that the array has no values in it,
it is just testing a particular element of the array.

Erase clears an array down, or as help puts it, Reinitializes the elements
of fixed-size arrays and releases dynamic-array storage space. But if the
array is empty, there is no need to clear it is there not?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Hemant_india" wrote in message
...
hi
is there any way to erase array elements having no values stored in it?
"if len(array(a,b))<=0 then erase"
will this work?
thanks
--
hemu