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
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
1 response
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