Copying Functions & Worksheet
 

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

Copying Functions & Worksheet
 

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" wrote in message
...
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

Copying Functions & Worksheet
 

Thanks. Worked like a charm.

"Bob Umlas" wrote in message
...
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" wrote in message
...
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