Ok, this code works fine:
Code
detailsSheet.Cells.Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
But conscious that using Selection can be slower, I tried:
This gives me a compile error, "named argument not found".
(details.Sheet is set elsewhere, on a user form, as a worksheet)
Also posted here: http://www.mrexcel.com/forum/e…nd-error.html#post4548758