copy and paste to multiple cell
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.
|