View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tran1728 tran1728 is offline
external usenet poster
 
Posts: 28
Default Copy and paste to the last row

Dear ALL, pls help me for macro.
I want copy the last row of column A, B and C.
and Paste the row down.

Example, my last row of A is A120, copy cell A120:C120.
then Past to A121

Thanks so much