View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Inserting multiple rows...

One way:

ws.Rows(j + 1).Resize(i - 1).Insert

In article . com,
Sonnich Jensen wrote:

How do I insert multiple rows at once?

Like

ws.Rows(j + 1).Insert i - 1

this adds one row, I need i-1 rows

I cannot find it in the help, or do I need a for loop?

WBR
Sonnich