Need code to copy from "code modules"

[davidm]

I am looking for (looping) code to copy the contents of the
Personal.xls project onto a worksheet (say, Sheet1). I have in excess
of 50 modules with some modules containing up to 8 sub procedures and
functions.

TIA

 

[David McRitchie]

See Chip Pearson's page Coding for the VBE
http://www.cpearson.com/excel/vbe.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Bob Phillips]

If you want to analyse that code, why not use Rob Bovey's code documenter
http://www.appspro.com/Utilities/Documentor.htm