| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting the array size to Zero.
Hi,
How do I reset the size of a One-Dimensional array to ZERO elements. The array in question is a Public array Public flag() As Byte Within some For loop I define the array to be of some size using "ReDim Preserve flag(UBound(flag) + 2)" After the for loop is over I want to redefine the size of the array to be NULL. How do i do it. I tried "ReDim flag() As Byte" but it is giving me a compile error. Please guide me. -- Thanks a lot, Hari India |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Resetting the array size to Zero.
erase flag
The important point is that it is a dynamic array. -- Regards, Tom Ogilvy "Hari Prasadh" wrote in message ... Hi, How do I reset the size of a One-Dimensional array to ZERO elements. The array in question is a Public array Public flag() As Byte Within some For loop I define the array to be of some size using "ReDim Preserve flag(UBound(flag) + 2)" After the for loop is over I want to redefine the size of the array to be NULL. How do i do it. I tried "ReDim flag() As Byte" but it is giving me a compile error. Please guide me. -- Thanks a lot, Hari India |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| URGENT! Need help on resetting an array | Excel Discussion (Misc queries) | |||
| How to find out the size of a variable-size array ? | Excel Programming | |||
| Array size limitation? | Excel Programming | |||
| Array Size | Excel Programming | |||
| Array size | Excel Programming | |||
Linear Mode
