2 or 3 rows, not just one

[JMay]

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]

Try something like

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


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