Do you mean only A19:AE19 or A1:AE19? And do you mean on the same
sheet?

The following will do what you ask:

Sub Test()
Range("A19:A19").Copy Destination:=Range("A20")
End Sub

or

Sub Test()
Range("A1:A19").Copy Destination:=Range("A20")
End Sub

But I suspect this isn't going to be too helpful for you (it only ever
copies A1:AE19 or A19:Ae19).

Perhaps you could expand on exactly what you are doing?

Richard


JAXIE wrote:
What I have is a range (A to AE 19) that I want to copy and paste below the
frisr range. Is there a way to do this with a macro ?? It is for a printout
for doing inventory in our warehouse and I am stuck on this so I am doing
this manually for now.