View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Insertting multiple rows

JE McGimpsey posted the following answer to your previous post:-

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

regards,

OssieMac

"Sonnich Jensen" wrote:

I wrote about this yesterday, but I cannot find the message today...

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

Is there a waym, besides a for-loop, to insert multiple rows in one
step?

WBR
Sonnich