Try it. Record the actions as you carry them out manually.

You may need to modify the code produced but it will you a start.

Regards

Trevor


"Ken Roberts" <Ken wrote in message
...
Can I do the following within a macro:

1. Open a second Excel document to copy a column from it; return to the
working document, paste the column of data in it.

2. Run a variety of calculations (already doing this).

3. Eliminiate worksheets within the primary document (with useless
information).

4. Add a worksheet so that I can save once in Excel format, once in text
format and once in csv format.

Thanks.