Hi..

I then use the following commands to add the guest to range named Guest_DB.
Your sheet is named "Guest_DB".. so i assume that that is a 'typo'... and therefore assume your Named Range is called "GuestIP"?

Here's a way you can increase the size(by 1 row) of your Named Range...

ActiveWorkbook.Names.Add Name:="GuestIP", RefersToR1C1:= _
            .Range("GuestIP").Offset(1, 0)

It basically 're-adds' your named range and increases the row size by 1...
Does that make sense?