probably a simple one to your geniuses however I need a fresh pair of eyes as I've been on this a while and can't see my error. I'm merely wanting to copy the contents of a cell from one cell to another cell on another sheet, but I don't want all the formatting to go with it, only the value.
My code is below
Range("H" & Target.Row).Copy Destination:=Sheets("Accepted Template").Range("P4").PasteSpecial Paste:=xlPasteValues
Any idea what I have done wrong here. VBA keeps throwing out an unexpected end error.