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,