Migrating from Copy - Destination to Paste Values

[zyry0301]

I'm new to VBA. I have a simple snippet, it uses Copy Destination...however I need to paste VALUES. I believe I can't use destination in order to do this, however all of my attempts have caused issues. Any thoughts on a simple fix? Thanks!

Sub MoveSC()
    Dim i As Variant
    Dim endrow As Integer
    Dim CL As Worksheet, SC As Worksheet
    
    'clears contents of scorecard
    Worksheets("Scorecard").Activate
    ActiveSheet.Range("A1:AA50").ClearContents


    Set CL = ActiveWorkbook.Sheets("Control")
    Set SC = ActiveWorkbook.Sheets("Scorecard")


    endrow = CL.Range("A" & CL.Rows.count).End(xlUp).row


    For i = 2 To endrow
        If CL.Cells(i, "M").Value = "1" Then
[B]           CL.Cells(i, "M").EntireRow.Copy Destination:=SC.Range("A" & SC.Rows.count).End(xlUp).Offset(1)[/B]
        End If
    Next
End Sub

 

[Jerry Sullivan]

Welcome to MrExcel,

To do that, you would replace that statement with two statements:

   CL.Cells(i, "M").EntireRow.Copy 
   SC.Range("A" & SC.Rows.count).End(xlUp).Offset(1).PasteSpecial(xlPasteValues)