View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] nicolas.gendron@gmail.com[_2_] is offline
external usenet poster
 
Posts: 9
Default Range ... how to know if it is empty

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