Cells.Find method?

[pujo]

I am trying to use a bit of code to find a value from on sheet to the master sheet.
Not sure of the correct syntax to reference the "Find" function to a specific sheet.
VBA below.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
 Dim var As Variant
  var = ActiveCell.Value
 
        Cells.Find(What:=var, After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=Sheets("MASTER"), SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate
 
End Sub

Anyone know the correct syntax?
Thanks for the assistance!

 

[Fluff]

How about

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   Dim Fnd As Range
   Set Fnd = Sheets("Master").UsedRange.Find(Target.Value, , xlFormulas, xlWhole, , , False, , False)
   If Not Fnd Is Nothing Then Application.Goto Fnd
End Sub