Macro: Insert blank row variable n times
Closed
hrvatski
Posts
1
Registration date
Monday August 13, 2012
Status
Member
Last seen
August 13, 2012
-
Aug 13, 2012 at 09:15 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Aug 16, 2012 at 01:22 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Aug 16, 2012 at 01:22 AM
Related:
- Macro: Insert blank row variable n times
- Excel duplicate rows n times ✓ - Excel Forum
- Disk boot failure insert system disk - Guide
- You have guessed too many times ✓ - WhatsApp Forum
- Macro to insert row in excel based on criteria - Excel Forum
- Excel macro to insert rows between data - Excel Forum
1 reply
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Aug 16, 2012 at 01:22 AM
Aug 16, 2012 at 01:22 AM
use following Codes:
for I = 1 to n Selection.Offset(1, 0).EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove ' you can use Range reference instead of selection. next i