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!!

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!!