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