inserting a row

G

Guest

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

Bob Phillips

Maybe

CoverWS.Rows(18).Insert


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1
Changes in How Code Acts After Upgrade of Excel 2
error in XValues 1
Autofit on Merged Cells. 5
COMException With Microsoft.Office.Interop.Excel 4
Inserting Lines using multiple Macros 1
Inserting a Copied Row inside a table 6
Inserting Row 3

Top