Thanks Yuri.


>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