Showing the VBA for find function from recording macro

[thomassharp]

Hi everyone, I want to modify some code that will use a named range from one sheet to find a row in another sheet and then if found paste that row to a new sheet. I've fallen a the first hurdle as recording didn't display the find. So my question is how to use the find function with this. Aware that it will need a lot of modification but thought this was the best place to start so I understand all the steps

Sub Macro4()
'
' Macro4 Macro
'


'
    Range("M6").Select
    Selection.Copy
    Sheets("Sheet1").Select
    Rows("8097:8097").Select
    Range("E8097").Activate
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet4").Select
    Rows("2:2").Select
    ActiveSheet.Paste
End Sub

Any help at all would be great. Thank you