hi
manually, coping the sheet then pasting it into a new book works good.
with code...
Sub addmore()
ActiveSheet.UsedRange.Copy
'Cells.Copy' or copy the whole sheet
Workbooks.Add
'Worksheets.Add'or to a new sheet in the same book
Range("A1").PasteSpecial xlPasteAll
msgbox "Done"
End sub
which is best? both work....how often do you do this or need to do this?

Regards
FSt1

"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