ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   can i reduce an array to size of 0 (https://www.excelbanter.com/excel-programming/316410-can-i-reduce-array-size-0-a.html)

Steven Deng

can i reduce an array to size of 0
 
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



NickHK

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





Steven Deng

can i reduce an array to size of 0
 
Thanks! Good to be in this group and get the fast answers


Sincerely,
Steven Deng





All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com