UPDATED: Added File New Row Macro Autoupdate Line...

[Pgm_Mgr]

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

[Mumps1]

It would be easier to help if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

[Pgm_Mgr]

Thanks for the tip... should have thought about that. Thanks for the insight.

[Mumps1]

Try the attached file. The macro is in Module1. Please note that I had to unmerge the cells in rows 13, 15 and 17. You should avoid using merged cells because they create havoc for macros. I have formatted the cells using "CenterAcrossSelection" which has the same visual effect as merging without actually merging the cells. The text appears in the center but is actually in column A. When entering data in the new rows, simply click in column A and enter your data.