View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default How to copy a range

Range("A1:E1").Copy Range("A2")

HTH

Die_Another_Day
Jentan wrote:
Anyone out there can teach me how to copy a range(say row A1 - E1) to
row A2-E2 using the range command.
thanks