One way:
With Range("A1:E1")
.Copy destination:=.Offset(1,0)
End With

HTH
--
AP

"Jentan" a écrit dans le message de news:
...
Anyone out there can teach me how to copy a range(say row A1 - E1) to
row A2-E2 using the range command.
thanks