Adding a Row to Excel SS using OLE

  • Thread starter Thread starter Bob Watson
  • Start date Start date
B

Bob Watson

I need to add a new row to an existing
Excel spreadsheet using OLE. Assuming
it is ROW=11 what would be the
proper VBA command?

Thanks for any help,
Bob
 
Am Mon, 17 Apr 2006 10:01:24 -0400 schrieb Bob Watson:


Bob, you don´t need (and can´t) add rows to the Spreadsheet. It has always
65,000 and a few more (you can see it by srolling to the end).
 
Sorry about that ... let me improve my request.
How do you insert a row? Say a new row at Row=11.

Thanks,
Bob
 
Am Tue, 18 Apr 2006 10:32:16 -0400 schrieb Bob Watson:

Ok, please see the Insert function of the Range object in the VBA help.

BTW: This group is for Outlook, not for Excel.
 
Back
Top