OK, I've looked for solutions to this issue, but I'm not sure I'm using the right search criteria. Here's the gist:
So I have a meeting tracking document that I want to use, the problem I'm having is I've created a new row button to automate inserting new rows however, if I click the new row button in line 13 it breaks the new row buttons in lines 15 and 17 because the macro no longer points to the correct line. I'm sure there's a way to do this, I just need one of you smart folks to point me in the right direction.
The code I'm using is below and the file is attached. Any help would be GREATLY appreciated.
Sub NewRowSummary_Click()
Sheets("Template").Range("A20").Select
ActiveCell.EntireRow.Insert Shift:=xlDown
Sheets("Template").Range("A20:D20").Select
Selection.Borders.Weight = xlThin
Sheets("Template").Range("A20:D20").Merge
End Sub
Bookmarks