Why not just use
right click sheet tabmove or copycopyselect the workbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

<JoJo wrote in message ...
Folks:


I would like to copy and paste a spreadsheet from one workbook to another.
All the formatting and column widths should deinitely be to be transferred
as well.

* Would the PASTE SPECIAL accomplish this for me ?


Thanks,
John