Have a look at this link...

http://www.cpearson.com/excel/vbe.htm
--
HTH...

Jim Thomlinson


"Mel Monroe" wrote:

I am using a VBA to spawn a spreadsheet as a subset from a larger database
and would like to port a pre-coded module from the main spreadsheet into the
new, spawned one. Does anyone know how I can copy modules wholesale using
VBA into a new spreadsheet?