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!
Code:
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
Last edited by a moderator: