- Select all the code to be copied
- Press Control+C
- Open the target code sheet
- Place the cursor where you want to code to go
- Press Control+V
When the task is to transfer all the code in one module from one workbook to another follow this procedure:-
- Open both workbooks
- Open the Project Explorer window in the VB Editor
- Drag the module from where it is to where you want the copy
- A copy will be made
- The original remains in its place