Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
developer
active.documents
automation
binary.file_format
clipboard.dde
com.add_ins
hosting.controls
internet_other
office.sdks
officedev
officedev.other
outlook.forms
outlook.vba
smarttags
vba
web.components
  
 
date: Thu, 19 Jun 2008 09:59:24 -0700 (PDT),    group: microsoft.public.office.developer.web.components        back       


how to delete rows in OWC10 spreadsheet?   
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!
date: Thu, 19 Jun 2008 09:59:24 -0700 (PDT)   author:   unknown

RE: how to delete rows in OWC10 spreadsheet?   
deleting  row in owc 10 employ delete not deleterows

for i=1 to 5
 spreadsheet1.ActiveSheet.rows(i).Delete
next
date: Sat, 28 Jun 2008 18:46:01 -0700   author:   jtz

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us