Thread: Copy Paste in Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Copy Paste in Macro
How do I reduce the coding involved in this statement.
FinalRow is just an integer value. Thanks you


Range("A2:D" & FinalRow).Select
Selection.Copy
Range("E2:H" & FinalRow).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A2").Select
Reply With QuoteReply With Quote