If you put it in a general module, it will be global to the workbook
If you put it in a general module, make the workbook and addin and then load
the addin, it will be global to any open workbooks - like the analysis
toolpak (which is an addin) when loaded.
Here is a link to an article on Addins
http://www.jkp-ads.com/articles/DistributeMacro00.htm
--
Regards,
Tom Ogilvy
"Glen" wrote in message
...
Hi Tom,
Sorry that I had forgotten to mention that th enumbers were variable in
length but you caught it.
I am guessing that I might be able to create my own "chunk" function based
on what you have given ... ie so I could just input the number of "chunks"
that I want from a cell.
If true then is there a way to make it a global function or would I need
to
put the code in each module?
thanks,
Glen