how to delete rows in OWC10 spreadsheet?

B

barbara_dave

Hi All,

I have the following code working for OWC, but it doesn't work for
OWC10.

spreadsheet1.ActiveSheet.Range("a1").DeleteRows(5)

it deletes row1 to row5. Does somebody know how to make it work for
OWC10?

Thanks for the help!
 
J

jtz

deleting row in owc 10 employ delete not deleterows

for i=1 to 5
spreadsheet1.ActiveSheet.rows(i).Delete
next
 

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

Why OWC10 chart binding to the spreadsheet doesn't work? 3
How to configuration the spreadsheet in XP Web Component 1
How to delete columns in OWC10? 2
How to automate update on weekly reports spreadsheet 0
OWC10 Chart binding with OWC10 Spreadsheet not working 2
Multiple Scatter Lines Series in a Chart. 0
OWC10 and XLMData 4
OWC10 Chart in VB: Mouse Events cannot fire 1

Top