The code found here works well for me.

http://www.rondebruin.nl/copy7.htm

"kirkm" wrote:


What's the best way to move a whole sheet from one .xls to another?

Can you click and drag ? Or use code ?

The move, insert, copy options seen to be only within the same .xls

Thanks - Kirk