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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1
Need Help with a VBA subroutine 0
Cannot edit OWC in design mode 1
Compare two different workbook sheet to show the difference in text 0
Excel 2010 for PC doesnt work on Excel Mac 2011. 11

Top