Hi,
I am trying to copy entire row 20 and paste as special value on same row.
I am using below code however receiving Run-time error '1004" error because paste function. Can anyone help me with the error?
I am trying to copy entire row 20 and paste as special value on same row.
I am using below code however receiving Run-time error '1004" error because paste function. Can anyone help me with the error?
Sub CopyPaste()
Application.ScreenUpdating = False
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ActiveWorkbook
Set ws = Sheets("Summary by L5")
wb.Activate
ws.Select
ws.Rows(20).EntireRow.Copy
ws.Rows(20).PasteSpecial Paste:=xlPasteValues
Application.ScreenUpdating = True
End Sub