View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
art art is offline
external usenet poster
 
Posts: 22
Default Streamline copying and pasting code

H
I would like to simplify this code to copy stuff from one worksheet to another. How can this be done

Worksheets(Wks).Select
Range("A5").Select
Selection.Copy
Worksheets("Printout").Select
Range("A6").Select
ActiveSheet.Paste

Also, is there a way to copy more than one item at a time, like the clipboard does

Thanks, and have a great day

Ar