View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Secret Squirrel Secret Squirrel is offline
external usenet poster
 
Posts: 172
Default 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