Paste Special Values but keep formatting and column widths
 

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

--
drdavidg
-----------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...fo&userid=3616
View this thread: http://www.excelforum.com/showthread.php?threadid=56117

Paste Special Values but keep formatting and 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