can i change this vba line so it just pastes values?

[tonywatsonhelp]

Hi Everyone,

Can I change this vba line so it just copys and pastes the values?

srcWS.Rows(qty.Row).EntireRow.Copy desWS.Cells(desWS.Rows.Count, "A").End(xlUp).Offset(1, 0)

thanks

tony

 

[Norie]

Tony

Try this.

desWS.Cells(desWS.Rows.Count, "A").End(xlUp).Offset(1, 0).EntireRow.Value = srcWS.Rows(qty.Row).EntireRow.Value