Thread: how to copy entire row into next row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
  
Posts: 1,092
Default how to copy entire row into next row
Rows("1:1").Copy Destination:=Rows("2:2")

"john_liu" wrote in message
...
how can i copy an entrie row into the next row by macro. Thanks for your
help




Reply With QuoteReply With Quote