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

You can count the number of occupied cells and see if it is zero. For
instance:
If Application.COUNTA(TheRange) = 0 Then .............
HTH Otto
wrote in message
oups.com...
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

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,


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505366

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