Need help with UsedRange (OWC Excel)

J

JK

Hi,

How can I select a range (and get the HTMLData) that contains only cells
with non-empty values in OWC10 Excel?

I tried:

MyExcelObject.ActiveSheet.UsedRange.CurrentRegion.HTMLData
MyExcelObject.ActiveSheet.Range("A2").CurrentRegion.HTMLData

But the range still contains cells that have a formula in it, even if the
the formula evaluates to an empty string ""

Any help would be great

Joost
 
Top