I am not seeing that:

Sub Macro1()
Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Range("C2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

works just fine
--
Gary''s Student - gsnu201003


"Nick H" wrote:

This line in a peice of code I've inherited, is pasting formats as
well as values...

Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, _
SkipBlanks:=False

....can anyone suggest why or how I get it to only paste values?

In case its relevant, I've also found that if I add the argument
Transpose:=False then it will fail with a 1004 error.

Br, Nick
.