New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

Copy Code Between Worksheets / Workbooks

Free Excel Tips and Tutorials
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

Copy Code Between Worksheets / Workbooks

Postby Sisyphus » Sun May 27, 2012 11:43 pm

This is the easiest way to copy code from one worksheet to another, whether in the same workbook or not:-
  • 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
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 1 guest