Thread
:
Auto insert blank rows
View Single Post
#
2
Posted to microsoft.public.excel.programming
merjet
external usenet poster
Posts: 812
Auto insert blank rows
Sub InsertRows_()
Dim iEnd As Long
Dim iRow As Long
iEnd = Range("A1").CurrentRegion.Rows.Count
For iRow = iEnd To 1 Step -1
Rows(iRow + 1).Insert xlShiftDown
Next iRow
End Sub
Merjet
Reply With Quote
merjet
View Public Profile
Find all posts by merjet