Need code to copy from "code modules"
 

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


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=386038

Need code to copy from "code modules"
 

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

"davidm" wrote in message
...

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


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=386038

Need code to copy from "code modules"
 

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

--
HTH

Bob Phillips

"davidm" wrote in
message ...

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


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=386038