New Excel Forum

This forum has been moved to

Ask all future questions in the New Excel Forum.


Copy Code Between Worksheets / Workbooks

Free Excel Tips and Tutorials

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

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)
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: Google Adsense [Bot] and 5 guests