Thread: Insert
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John McGimpsey John McGimpsey is offline
external usenet poster
 
Posts: 11
Default 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)