Adding row to a named range-updating the named range address

I have a file to keep records of RV park guest.
I use a row of data range named GuestIP where I enter the data for each new guest.

I then use the following commands to add the guest to range named Guest_DB.

Sheets("Guest-DB").Range("GuestIP").Copy
    Sheets("Guest-DB").Range("C" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues
    Sheets("Guest-DB").Range("c" & Rows.Count).End(xlUp).PasteSpecial xlPasteFormats

However this does not change the address of the Guest-DB to include the added guest.

ie Before adding the new guest the Guest-DB address is C6:AB564, after updating the address is still C6:AB564 needs to be C6:AB565.

vlookup commands else where in the workbook cannot find the new guest until I manually change the Address to include the row with the new guest.

Is there a way to change the range address when you add a row to the bottom of the range?

Any help would be appreciated.