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
 
Top