I am trying to copy an enitre worksheet to another worksheet in a new
workbook. In XL 2003 and prior all you had to do was highligh all the cells
by clicking top left corner then copy and go to the new workbook, select all
the celss via the same mtehod and paste. This would copy everything,
including the formats of the cells.

In XL 2007 it copies everything, except the formatting. How do I copy it so
the formatting comes across as well?

BVass