Paste Values rather than formula VBA

[stroffso]

Hi,

I have some code where its picking data from one sheet and dropping it into another. However i just have a small issue with one piece as its pasting the actual formula rather than just the values. can someone advise with what I am missing or what I need here to do it?

Sub Copyover
Sheets("Master sheet").Range("A5").Copy _
Destination:=Sheets("New Sheet").Cells(Cells.Rows.Count, _
1).End(xlUp).Offset(0, 4)

End Sub

thanks in advance

 

[alansidman]

[COLOR=#333333]Destination:=Sheets("New Sheet").Cells(Cells.Rows.Count, _[/COLOR]
[COLOR=#333333]1).End(xlUp).Offset(0, 4).PasteSpecial Values[/COLOR]

 

[stroffso]

I tried that previously but a compile error occured stating unexpected end of statement. I have done a workaround anyhow so all is good, thanks

 

[Beyond_avarice]

Sub justSayNotoCopyPaste()

Sheets("New Sheet").Cells(Cells.Rows.Count, _
1).End(xlUp).Offset(0, 4).Value = Sheets("Master sheet").Range("A5").Value

End Sub