Afternoon, All.

How would I code to find the value of a particular cell? For example, a part number is entered into a cell on one worksheet, and the user clicks a button to find that part on another sheet.

Here is what I have, but I get an error:
Sub Find_Part()
    Sheets("New US").Select
    Cells.Find(What:=value.('Part Entry'!:F3), After:=ActiveCell, LookIn:= _
        xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
        xlNext, MatchCase:=False, SearchFormat:=False).Activate
End Sub
Thanks in advance for any help.

Hutch