(Solved) – How to add specific value in a cell when adding new row with VBA

(solved)-–-how-to-add-specific-value-in-a-cell-when-adding-new-row-with-vba

This is my little VBA code to add a row

Sub insert()
 Range("A2").EntireRow.insert
End Sub

I would like to add “hi@google.com” in every “L” cells when adding a new row.

I can’t figure out how

I tried this but no luck :

Sub insert()
 Range("A2").EntireRow.insert
Cells(2, 12).Value = hi@google.com
End Sub

Leave a Reply

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