Sub Find_Error()
Dim rng, rng2 As Range
Dim I As Integer
For I = 2 To Sheet2.Range("a65536").End(xlUp).Row
If I = 2 Then
Set rng = Sheet1.UsedRange.Find(Sheet2.Range("d" & I).Value)
Set rng2 = rng.Offset(-3, 0).Resize(3, 1)
Else
Set rng = Sheet1.UsedRange.Find(Sheet2.Range("d" & I).Value)
Set rng2 = Application.Union(rng2, rng.Offset(-3, 0).Resize(3, 1))
End If
Next
rng2.Select
End Sub