vba - How to create an empty array of Double -
i trying create empty/defined array of double
reflect double(0, -1)
.
i'm able create 1 array of string
, variant
, byte
:
dim arr_variant() variant arr_variant = array() ' variant(0 -1) ' dim arr_string() string arr_string = split(empty) ' string(0 -1) ' dim arr_byte() byte arr_byte = "" ' byte(0 -1) ' dim arr_double() double arr_double = ??? ' double(0 -1) '
, still haven't found way double
.
maybe lset
or native function?
i go - not possible.
take @ following code:
option explicit sub testme() dim arr 'line 1 arr = array(cdbl(0)) 'line 2 arr = array(empty) 'line 3 end sub
- line 1 - takes variant array
- line 2 - makes double array
- line 3 - when emptied, converted double variant again.
Comments
Post a Comment