I just recorded a macro and got this..........
Sub TestPasteSpecial()
Range("A1").Select
Selection.Copy
Range("C1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
End Sub
Vaya con Dios,
Chuck, CABGx3
"Curt" wrote in message
...
I'm working on a macro and I need to Paste values only for a range. I
can't
get the help file for macros for some reason. I guess I just need to know
the propper syntax for that function if anyone knows. I'm using Excel
2002.
|