#Excel Short and Sweet Tip #22 (Move VBA Module Copy to Another Workbook) by David Hager

Did you that you can drap and drop a VBA module from one workbook to another? With both workbooks open, click down on a module in the VBE and, while holding the click, move the cursor to the module list in the other workbook and release. This actually does not move the module, it makes a copy! So, open your projects and start consolidating your modules in a master workbook. HTH!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s