Almost!

I now have the format (ie borders and cell borders) along with the values
but the column and row sizes are all back to default!

Nick

"Sean Timmons" wrote in message
...
Try doing copy-paste special values, then without moving anything, right
click again and do paste special, formats.

"Nick Wakeham" wrote:

I am using Office 2007 and want to copy a worksheet in an Excel workbook
that contains formats, values, and formulas - I want to copy everything
intact EXCEPT for the formulas. I have tried Copy and Paste Special but
that
either doesn't keep the format of the page or I get the format but no
values. What on earth am I doing wrong - I'm sure I used to just do a
Copy
and Paste Special and it worked but something somewhere has changed.

Help appreciated

Nick