adding rows to a table

Goodmorning,

I have a macro that adds a row to a table of names and account numbers. The code I have now is below:

Sheets("Controls").Select
    Range("N46:Q46").Select
    Selection.Insert Shift:=xlDown
    Range("N46").Select
    ActiveCell.FormulaR1C1 = "Enter Name"
    Range("Q46").Select
    ActiveCell.FormulaR1C1 = "Enter Number"

This works fine, but when I run this macro multiple times it only inserts the new row at row 46. Is there a way to alter this code (or do it completely differently) so that everytime I run the macro it inserts the row at the end of the table (i.e. row 47, 48, etc)?

Thanks.