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 www.twoperscent.com

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”

Code:
Sheets(“Sheet1”).Range(“A4”).Select
ActiveCell.EntireRow.insert Shift:=xlDown

Sheets(“Sheet1”).Range(“A4:E4”).Select
Selection.Borders.Weight = xlThin

Thanks for watching!

Post Author: OfficeTutes.com

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 *