Copy and Transfer + Content Clear Row Help VBA Excel 2003

I have the following Code in my Sheet5 but I need to have it for all rows:

Please Login or Register  to view this content.

So I need it for

A to P for all rows

Row starts at 5 and could go down all the way to 1000

Chnages to be done is Range("A5:P5").Copy

Error comes if I change it to Range("A:P").Copy

Please Help

Add:

The code needs to take all info on that row (A to P) and transfer to the next available "Empty" row.

If my info is in A6 to P6 then transfer to the next available row in my sheet ("Archives") Then Clear content of A6 to P6.
Same if I have info on A100 to P100. Find next available row then Copy info to sheet ("Archives") Then Clear content of A100 to P100.

The delete code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.