Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set array element to empty
I have an array that is type single and I would like to delete values that
meet a certain criteria. If the array was variant I could set the a particular array element to "". How do I do something similar for an array that is not variant? Thanks, Raul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set array element to empty
Hi Raul,
A Single does not have an "empty" value. Its initial value is 0. So the best you can do is set its value to 0 when you want to "clear" it. So, in your case, you may want to either 1) use a Variant array and set the values to be cleared to vbNullString (or ""); or 2) use a Single array as the source, and create a new Single array, copying only the values you need from the source array. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set array element to empty
Thanks a bunch for the quick and informative respsonse! In this case I'll go
with option 1. Thanks again, Raul "Jake Marx" wrote: Hi Raul, A Single does not have an "empty" value. Its initial value is 0. So the best you can do is set its value to 0 when you want to "clear" it. So, in your case, you may want to either 1) use a Variant array and set the values to be cleared to vbNullString (or ""); or 2) use a Single array as the source, and create a new Single array, copying only the values you need from the source array. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Array element | Excel Worksheet Functions | |||
Permutations of an array element < to a value | Excel Worksheet Functions | |||
Further Array Element question | Excel Programming | |||
Array element | Excel Programming | |||
deleting array element | Excel Programming |