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

twoperscent

Published: 21 Feb 2018 › Updated: 21 Feb 2018 Creating a macro in Microsoft Excel that will insert a new row

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

▶️ DTube
▶️ IPFS

Leave Creating a macro in Microsoft Excel that will insert a new row to:

Written by twoperscent

MMA Fan, Excel Blogger, Crypto Investor, Tropical Fish Keeper

Best Posts From twoperscent

We have not curated any of twoperscent's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.

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