Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying and Pasting | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Streamline macro code. | Excel Programming | |||
Streamline PivotTable creation code | Excel Programming | |||
Copying & Pasting | Excel Programming |