Thread: Copying UDFs from another worksheet?

I have several User Defined Functions in workbooks someone sent me.
Can I copy those UDFs into my Function Library?
And can I create a new category?
For example, "Astronomy Functions" in the Function Library.

I can "link" (I guess you might call it that) by keeping two workbooks open and copying and pasting functions from one sheet to the other. But that requires both books to be open. Once I close the one with the source function, the functions disappear in the other sheet.

I tried copying one book into another and that didn't work, either.

Thanks, Scott

You could just copy and paste the code. Or export the module from the source and import it to the target workbook.


Regards

Open both workbooks. Press Alt-F11 to open the VBE.

Navigate to the module with the UDFs in the source workbook.

Select and copy the code.

Navigate to the equivalent module in the target workbook.

Paste the UDF code.

Close the workbook(s).

Done.

Regards, TMS

You're welcome. Thanks for the rep.