Find Statement Returns Empty When Search In A Range With XLWhole Option Enabled

Find statement returns empty when i search in a range with XLWhole option enabled

Code:

Private Sub worksheet_change(ByVal Tar As Range) On Error Resume Next
If Tar.Column = 1 Then
Set f = Sheets("Sheet2").Range(Cells(1, 1), Cells(5000, 100)).Find(Tar(1, 1), LookAt:=xlWhole)

[Code]..

but when i use Cells instead of Range ,Find command returns perfect result

Code:

Private Sub worksheet_change(ByVal Tar As Range) On Error Resume Next
If Tar.Column = 1 Then
Set f = Sheets("Sheet2").Cells.Find(Tar(1, 1), LookAt:=xlWhole)
If f.Column = 11 Then Sheets("Sheet1").Cells(Tar.Row, Tar.Column + 1).Value _
= Sheets("Sheet2").Cells(f.Row, f.Column + 1).Value
End Sub