don't know if this helps, but I just recorded a macro where I copied
"paste values" to a new sheet. The result :

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/20/2004 by Scott
'

'
Range("C8:C16").Select
Selection.Copy
Sheets("Sheet2").Select
Range("C7").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone
SkipBlanks _
:=False, Transpose:=False
End Sub

I think that the key to your problem is the Paste value

--
Message posted from http://www.ExcelForum.com