Hi,

I have a piece of code I'm using to copy some values that are an external data table. How would I modify this so that, when I copy and paste, I only paste the values?

With Workbooks(Scoresheet).Worksheets("DataTable")
          LastRow = .Range("P" & .Rows.Count).End(xlUp).Row
          .Rows("1:" & LastRow).Copy Workbooks(Scoresheet).Worksheets("Imported").Range("A" & LastRow)
           Application.CutCopyMode = False
       End With
Many thanks in anticipation