J JMay Feb 1, 2004 #1 Within a loop the following line Inserts 1 row; How would I instruct/change it to Insert 3 rows? Rows(i + 1).Insert TIA,
Within a loop the following line Inserts 1 row; How would I instruct/change it to Insert 3 rows? Rows(i + 1).Insert TIA,
C Chip Pearson Feb 1, 2004 #2 Try something like Rows(i + 1).Resize(3).Insert -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Try something like Rows(i + 1).Resize(3).Insert -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
