I need to transfer a custom function from one workbook to another. At
first, I thought that simply copying the worksheet where the function is
operative to the other workbook would do the trick, but no luck. My thanks
in advance if someone could point out the method. BR

Go to the VBE, Alt-F11, and locate the code module. Copy the function,
select the other workbook, Insert a code module, and paste it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brad Reid" wrote in message
...
I need to transfer a custom function from one workbook to another. At
first, I thought that simply copying the worksheet where the function is
operative to the other workbook would do the trick, but no luck. My thanks
in advance if someone could point out the method. BR

If the custom function is build with VBA, then with the workbook containing
the code open, you can reference it with

=CustomFunctionBook.xls!CustomFunctionName(arg1, arg2)

--
Regards,
Tom Ogilvy

"Brad Reid" wrote in message
...
I need to transfer a custom function from one workbook to another. At
first, I thought that simply copying the worksheet where the function is
operative to the other workbook would do the trick, but no luck. My thanks
in advance if someone could point out the method. BR