Macro: Insert blank row variable n times
Closed
hrvatski
RWomanizer
- Posts
- 1
- Registration date
- Monday August 13, 2012
- Status
- Member
- Last seen
- August 13, 2012
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Related:
- Macro: Insert blank row variable n times
- How to insert blank rows using macros in Excel - Guide
- Insert blank row when value changes in excel using vba ✓ - Forum - Excel
- Copy and insert each row multiple times based on a specific number ✓ - Forum - Excel
- How to duplicate rows x number of times - Forum - Excel
- Excel vba insert multiple blank rows - Forum - Excel
1 reply
RWomanizer
Aug 16, 2012 at 01:22 AM
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
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