View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Set an array to zero


Two ways and best to see the details in the help file:
Redim
Erase

RBS


"T.Mad" wrote in message
...
Hi all,
How can I set an array to zero without looping to every element? For
example
in FORTRAN with a single assignment e.g. Array=0 you can do that. Is there
a
similar way in vba?
Many thanks