Hello fellow Excel users,

I'm struggling to come up with a solution to the below code. It works almost perfectly, but instead of copying formulas from the rows I select, I need the code to paste values.

Any chance that someone could help?

Sub CopySelectedRows()
  Dim rCopy As Range
  Dim lAreas As Long
  
  On Error Resume Next
  Set rCopy = Application.InputBox("Select Rows to copy. " _
  & "Use Ctrl for non-contiguous rows", "COPY ROWS", Selection.Address, , , , , 8)
  On Error GoTo 0
  If rCopy Is Nothing Then Exit Sub 'Hit Cancel
  
  If rCopy.Columns.Count <> Columns.Count Then
     MsgBox "Please select entire row(s)"
     Run "CopySelectedRows"
  Else
     For lAreas = 1 To rCopy.Areas.Count
        rCopy.Areas(lAreas).Copy Sheet1.Cells(Rows.Count, 1).End(xlUp)(2, 1)
        
     Next lAreas
  End If
  
End Sub
Many thanks in advance!