Creating a macro in Microsoft Excel that will insert 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

Please like and subscribe if this has helped you. Thanks for watching