Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, Im working with a dynamic array and have no problem assigning values to an
array, or working with the array in general. What Im having difficulty is deleting an item in the array then resizing. I know how to add items and resize using preserve. What Im doing is this. Say my array has 10 values, I use: For I = 1 to Ubound(myarray) then loop through the array looking to see if a value matches a certain criteria, if not I do nothing, if so (this bit I cant do) I want to remove that value from my array (leaving 9 values), resize the array then use my Ubound. Can this be done. Any advice would be appreciated Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fetching data and deleting original data | New Users to Excel | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
deleting array element | Excel Programming |