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]