If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Showing the VBA for find function from recording macro

Thread starter thomassharp
Start date Mar 26, 2015
Tags

find and copy vba

thomassharp

Board Regular

Mar 26, 2015

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

Code:

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