Range ... how to know if it is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nicolas.gendron@gmail.com - 26 Jan 2006 16:19 GMT

Hi,

I'm using COM automation inside an xll to program Excel.
At one point in the code, I do the following to retreive a Range of
cells :

"range = range.GetResize(COleVariant(rows), COleVariant(cols));"

Is there a way (other than iterate over all the cells in the range) to
know if the range is empty?

Thanks.

By the way, is there a place where I can find some documentation of
those Excel Ole object?

Nic

Reply to this Message

Otto Moehrbach - 26 Jan 2006 16:48 GMT

You can count the number of occupied cells and see if it is zero. For
instance:
If Application.COUNTA(TheRange) = 0 Then .............
HTH Otto

> Hi,
>
[quoted text clipped - 13 lines]
>
> Nic

Reply to this Message

tony h - 26 Jan 2006 17:07 GMT

have a look at the specialcells property of a range. You may find one of
these will answer your needs.

eg: Set rngb = rnga.SpecialCells(xlCellTypeBlanks)

Regards,

Signature

tony h

Reply to this Message

nicolas.gendron@gmail.com - 30 Jan 2006 15:23 GMT

Thanks, it works great.

And what if I have another representation of the Range like an XLOPER
array.

_result.xltype = xltypeMulti;
_result.val.array.lparray = xlValues;

where xlValues is an array of XLOPER

- Is there a way to take the array, make a COM Range object and call
the COUNTA function?

- Or should I loop over all elements of the array

- Or is there another undocumented C Api function for this ;-)

Thanks,

Nic

Reply to this Message