Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Depends on whether i want to resize the array or not. Delete would imply
that but is not definitive. Resizing, as you know, but maybe the OP doesn't, would require that the array be dynamic. Looping with hard coded bounds would imply fixed - but again, specifics were not provided. -- Regards, Tom Ogilvy "Alan Beban" wrote in message ... Tom Ogilvy wrote: a P Daulton has implied, there is no command to delete an element of an array. j = 1 for primat = 1 to 50 if newarr(primat) < 15 then newarr(j) = newarr(primat) j = j + 1 end if Next for i = j to 50 newarr(i) = 0 Next might be what you want. If you substitute the following for the second loop you probably have it: ReDim Preserve newarr(1 To j - 1) Alan Beban |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Array element | Excel Worksheet Functions | |||
Can one store a string in a Array element? | Excel Discussion (Misc queries) | |||
Search array and return element No | Excel Worksheet Functions | |||
Permutations of an array element < to a value | Excel Worksheet Functions | |||
deleting array element | Excel Programming |