View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default can i reduce an array to size of 0

Steven,
Check out "Erase" in the help.

NickHK


"Steven Deng" wrote in message
news:klBkd.181906$nl.102907@pd7tw3no...
Hello there,

I have a question regarding array size.

dim i() as integer
..... ' somecode

redim preserve i(1 to 10)


.... 'somecode


' and then here i would like to reduce it to size 0 (or undefined) , can

I
do that ? Your help or suggestion is highly appreciated!



Sincerely,
Steven Deng