View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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,