bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 831
- Office Version
- 365
- Platform
- Windows
I have the code below that i was hoping that there could be something modified so I could hit undo if the rows were not added at the correct place.
Code:
Sub Insert4()
Range(ActiveCell, ActiveCell.Offset(3, 14)).Select
Selection.EntireRow.Insert
For n = 7 To 10
Selection.Borders(n).LineStyle = xlContinuous
Selection.Borders(n).Weight = xlMedium
Next
For n = 11 To 12
Selection.Borders(n).LineStyle = xlContinuous
Selection.Borders(n).Weight = xlThin
Next
End Sub