Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting element in Array
I have a 1-D array. A Routine checks the cells in a range
and fills it (based on a test - boolean) with cell addresses. I want to run a second routine, which checks this same range and performs another test - boolean. If the boolean is false and this particular cell address already exists in the array, then I want to delete its existence in the array. How do I do this and redimension the array so that it no longer includes the deleted elements. THanks ?Array(0) $A$1 ?Array(1) $A$2 ?Array(2) $A$3 After the second check I would like to see: ?Array(0) $A$1 ?Array(1) $A$3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permutations of an array element < to a value | Excel Worksheet Functions | |||
Deleting an element in the middle of an array | Excel Programming | |||
Array element | Excel Programming | |||
Deleting data and element in a 1D array | Excel Programming | |||
deleting array element | Excel Programming |