ExcelBanter - 2 or 3 rows, not just one

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

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

- - 2 or 3 rows, not just one (https://www.excelbanter.com/excel-programming/289875-2-3-rows-not-just-one.html)

JMay

2 or 3 rows, not just one

Within a loop the following line Inserts 1 row; How would I instruct/change
it to Insert 3 rows?

Rows(i + 1).Insert

TIA,

Chip Pearson

2 or 3 rows, not just one

Try something like

Rows(i + 1).Resize(3).Insert

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"JMay" wrote in message
news:GL6Tb.14560$fZ6.8978@lakeread06...
Within a loop the following line Inserts 1 row; How would I
instruct/change
it to Insert 3 rows?

Rows(i + 1).Insert

TIA,

All times are GMT +1. The time now is 08:09 PM.