Copy and paste data from one sheet to another

[Jeffreyxx01]

Hi guys,
I tried to make this macros but I get the red code highlited in yellow when I run it,
Do someone know why?

Thanks for the help

Sub CopyData()

Dim LastRow As Long
Dim Sht As Worksheet




Worksheets("Datadump").Range("E:G,S:S,AW:AW,AY:AY,BE:BE,CC:CC,CF:CV").Copy


Set Sht = ThisWorkbook.Sheets("Clean")
With Worksheets("Clean")
[COLOR=#ff0000]LastRow = .Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row[/COLOR]
    Sht.Range("A1:Y" & LastRow).ClearContents
    .Range("A1").PasteSpecial xlPasteValues
End With


End Sub

 

[Fluff]

Duplication https://www.mrexcel.com/forum/excel...opy-paste-data-sheet-another.html#post4987535

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).