Copying Functions & Worksheet

[Peter]

Folks,

I am tyring to create a copy of s single worksheet 'Using Move or Copy"
Sheet from a workbook containing user defined functions. The sheet copies
fince but the user function (critical to the sheet) is not copied with it.

Is there a clean way to do this or should I create a copy of the workbook
and delete all but the worksheet I want to cretae a copy of?

Thanks,
Peter

 

[Bob Umlas]

The user-defined functions are in modules, not part of the sheet. You need
to copy both the sheet and the modules. The modules (or the Function you
want) can be copied by dragging across the code & use Copy & paste onto a
module in the new workbook, or you can export the module and import it into
the new workbook. It's also very possible there's extra code in the module
that you do NOT want, and you can delete it by selecting the code & pressing
delete.

 

[Peter]

Thanks. Worked like a charm.

The user-defined functions are in modules, not part of the sheet. You need
to copy both the sheet and the modules. The modules (or the Function you
want) can be copied by dragging across the code & use Copy & paste onto a
module in the new workbook, or you can export the module and import it into
the new workbook. It's also very possible there's extra code in the module
that you do NOT want, and you can delete it by selecting the code & pressing
delete.