Morning Guys and Girls,

I have a line of code I have been using to copy a cell and paste it in another sheet.

This has been working perfectly- however I would love it if it would paste values, rather than a regular paste.

here is my snippet of code I have been using:

Sheets("Diary").Range("C7").Copy Destination:=Sheets("Week 1").Range("D" & Sheets("Diary").Range("D33").Value)
and here is my attempt at adding the paste special (not working):

Sheets("Diary").Range("C7").Copy Destination:=Sheets("Week 1").Range("D" & Sheets("Diary").Range("D33").Value)  Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
Thanks in advance!

Hernan