Paste Special Values but keep formatting and column widths

Hey, Is there a easy way to copy a sheet and Paste-Special -> Values into another sheet but also keep any font/colors/background colors and the column widths?

cells.copy
with worksheets("Sheet2").Cells
.Pastespecial xlValues
.Pastespecial xlFormats
End with

--
Regards,
Tom Ogilvy


"drdavidge" wrote:

>
> Hey, Is there a easy way to copy a sheet and Paste-Special -> Values
> into another sheet but also keep any font/colors/background colors and
> the column widths?
>
>
> --
> drdavidge
> ------------------------------------------------------------------------
> drdavidge's Profile: http://www.excelforum.com/member.php...o&userid=36168
> View this thread: http://www.excelforum.com/showthread...hreadid=561176
>
>