ExcelBanter - Insertting multiple rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Insertting multiple rows (https://www.excelbanter.com/excel-programming/400391-insertting-multiple-rows.html)

Sonnich Jensen[_2_]

Insertting multiple rows

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

OssieMac

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

All times are GMT +1. The time now is 12:15 PM.