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
|