Insert
 

Excel.Worksheet.Rows.Insert(Shift as Object, CopyOriginal
as Object) as Object

My question is what Objects the Shift and CopyOriginal
should be. Also what is it returning? A row? A range?

I am trying to put an array (20-40 rows by 20 columns)
into a spreadsheet. The spreadsheet needs to make the rows
fit by inserting X amount of rows as needed. So a simply
insert row should work right? At least it does when I do
it manually. (Highlight a row, right click and select
insert)

Insert
 

Take a look at VBA Help. Both Shift and CopyOriginals should be
Variants. Help lists what to look for in the object browser.

In article ,
"Andy" wrote:

Excel.Worksheet.Rows.Insert(Shift as Object, CopyOriginal
as Object) as Object

My question is what Objects the Shift and CopyOriginal
should be. Also what is it returning? A row? A range?

I am trying to put an array (20-40 rows by 20 columns)
into a spreadsheet. The spreadsheet needs to make the rows
fit by inserting X amount of rows as needed. So a simply
insert row should work right? At least it does when I do
it manually. (Highlight a row, right click and select
insert)