Creating a macro in Microsoft Excel that will insert a new row.

About this tutorial:

Video duration: 5:
You can now download a copy of this worksheet from the link below at

Creating a Macro in Excel which will add a new row

A simple guide on how to create a macro in Microsoft Excel that will insert a gridlined new row at the location you specify. Please enter code below between “Private Sub” and “End Sub”

ActiveCell.EntireRow.insert Shift:=xlDown

Selection.Borders.Weight = xlThin

Thanks for watching!

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *