Code that copys the first row in my spreadsheet and pastes it in the first empty row avail

Hey there

What I need is VBA code that copys the first row in my spreadsheet and pastes it in the first empty row available (This is going to be at the bottom).

Sub macro_1()
rows(1).copy rows(range("A" & rows.count).end(xlup).row+1)
end sub

Thank you this worked perfectly