Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
here is something that might help. paste this code in a standard module and run it. Sub Macro1() Dim r1 As Range Dim r2 As Range Range("A6").Select Set r1 = Range("A6") 'assuming you have a header row Do While Not IsEmpty(r1) Set r2 = r1.Offset(4, 0) ActiveCell.EntireRow.Insert r1.Offset(4, 0).Select Set r1 = r2 Loop End Sub regards FSt1 "EmmaSB" wrote: I have a large file (1,000+ rows) and I need to insert a blank row after every four rows. Is there an easy way to do this without having to manually insert each row? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'Insert' 'Object' command: I have 11 blank rows of objects at top | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
automatically insert 8 blank rows between each record | Excel Discussion (Misc queries) | |||
Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
How to quickly insert a blank row every 5 rows? | Excel Discussion (Misc queries) |