Jim,

1. Open the file you want to copy code from, go to VBA Editor, right_click on appropriate module, choose "Export file" and save it as filename.bas file.
2. Open the file you want to copy code to, go to VBA Editor, right_click on VBAProject or Excel Objects, choose "Import File", select filename.bas file.


>I've got some code that does something for me, added through the VBA Editor feature while in an Excel workbook.
>
>I now want to use that code in another worksheet. Knowing NOTHING about how these things *should* be done, I observed an "Export" option in the VBA editor. So I used it, and it created a file for me (.CLS).
>
>I then opened up the xls file where I wanted to use that code, opened the VBA Editor and used "IMPORT" and it seemed to run OK.
>BUT there's no sign of the code in the new worksheet.
>
>Can someone advise how I should properly do what I am trying to do?
>Thanks