Hi
What should I add to this code so it would paste values only? I tried adding .Value to end on Range("B1"), but it doesn't work.
![]()
Workbooks("base").Sheets("VM").Range("F1").Select Range(Selection, Selection.End(xlDown)).Copy _ Destination:=Workbooks("result.xlsx").Sheets("testdata").Range("B1")
Bookmarks