Hi Richard
Check out this webpage
http://www.cpearson.com/excel/vbe.htm
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Richard Butz" wrote in message ...
I would like to find out if I can write a macro that
writes and saves modules in Excel. I have a repetive
task that will create an array based upon a interations
fo a permutation of outcomes. I then want to use the
contents of the array to name and create a module for
each interation.