I'm trying to look through some workbooks to find what cells have a
particular cell ame in the formulae, but it debugs on doeesn't support the
method in lookin=xlFormulas or using the constant -4123.
the code is
With ActiveWorkbook
Set C = .Find(Tsh.Range("C" & cnt).Value, -4123)
If Not C Is Nothing Then
firstAddress = C.Address
Do
If Not Err.Number = 91 Then: Tsh.Range(cl &
cnt).Value = "Y": Exit Do
If Err.Number = 91 Then: Err.Clear
Set C = .FindNext(C)
Loop While Not C Is Nothing And C.Address <
firstAddress
End If
End With

Could someone help with this one please? Regards, Brett