Transferring custom function

B

Brad Reid

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
 
B

Bob Phillips

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)
 
T

Tom Ogilvy

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)
 
Top