Copy A Range of Cells Or Sheet and Paste to A New Workbook

[Nathan123]

I need to copy a range of cells or the entire first sheet and place it in a new workbook. There are other sheets in the original workbook that dont need to be copied. Here is what I have so far.

Please Login or Register  to view this content.

[davesexcel]

This command copies sheet1 to a new workbook.

Please Login or Register  to view this content.

check out this thread for additional info

http://www.excelforum.com/showthread.php?t=592310