See http://www.mrexcel.com/articles/past...o-into-vbe.php
instead of copying from the website you will have to copy the macro from
your spreadsheet with the macro you want.

Ideally frequently used macros are written in PERSONAL.xls which is
available to all workbooks.
See http://visualbasic.about.com/od/lear.../aa022203a.htm to start
learning about it.

"Andy" wrote:

Good Morning,

I have been given an excel spreadsheet that has an excellent interpolation
marco in it. I now want to use this macro on another spreadsheet. Does
anyone know how i can copy the makro from one sheet to another? Is it
possible to save frequently used macros's into a directory where i can pull
then out from when required?

Thanks very much.

Andy