Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting a row
I'm using VB.NET to create an application that opens an Excel worksheet.
I need to insert a row. I've tried to use the code: CoverWS.Rows.Insert(18) I am getting an error: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in mscorlib.dll Additional information: Cannot shift objects off sheet. Can anyone tell me what I'm doing wrong? Thanks in Advance!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting a row
Maybe
CoverWS.Rows(18).Insert -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Elena" wrote in message ... I'm using VB.NET to create an application that opens an Excel worksheet. I need to insert a row. I've tried to use the code: CoverWS.Rows.Insert(18) I am getting an error: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in mscorlib.dll Additional information: Cannot shift objects off sheet. Can anyone tell me what I'm doing wrong? Thanks in Advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting new row | Excel Worksheet Functions | |||
Inserting a Row | Excel Worksheet Functions | |||
Inserting row | Excel Discussion (Misc queries) | |||
Inserting a row | Excel Programming | |||
inserting a row | Excel Programming |