B
Boris
Hi, I am trying to find a way of determining whether variables (in a large
array of 35000 data points, defined as Single) are actually blank or are
really zero.
I appreciate that numeric variables default to 0. In my case, I dimension my
large array as single, then set it equal to a range. The range will contain
empty cells (perhaps up to half the time), signifying missing data, but may
also contain data values that are 0. I want to distinguish between these
possibilities. I appreciate that I could declare the array as variant or
string, then test to see if individual elements are blank or null string,
then convert as necessary to numeric variable, perform my operations and so
on but this would seem to be a very inefficient process.
Is there some more efficient way of determining whether a numeric variable
has been changed from its default initialisation value? Or is there some way
that I can simply instruct VBA to set all blanks in the range I am reading in
(which is large) to some other value? Or can I change the default value that
VBA gives to a particular variable type?
Any help, as always, would be most gratefully appreciated.
Many thanks, Boris.
array of 35000 data points, defined as Single) are actually blank or are
really zero.
I appreciate that numeric variables default to 0. In my case, I dimension my
large array as single, then set it equal to a range. The range will contain
empty cells (perhaps up to half the time), signifying missing data, but may
also contain data values that are 0. I want to distinguish between these
possibilities. I appreciate that I could declare the array as variant or
string, then test to see if individual elements are blank or null string,
then convert as necessary to numeric variable, perform my operations and so
on but this would seem to be a very inefficient process.
Is there some more efficient way of determining whether a numeric variable
has been changed from its default initialisation value? Or is there some way
that I can simply instruct VBA to set all blanks in the range I am reading in
(which is large) to some other value? Or can I change the default value that
VBA gives to a particular variable type?
Any help, as always, would be most gratefully appreciated.
Many thanks, Boris.