Copy & Paste Special Macro
I'm trying to write a macro to cut and paste values only from one worksheet
to another. I have the copy and paste down but I don't know how to do the
"paste special" part. Can anyone help?
Public CopyOne()
Worksheets("Sheet2").Range("A1:C8").Copy _
Destination:=Worksheets("Sheet3").Range("A1")
End Sub
|