Formula from other sheet(s)

[sunan]

If we: "goto - special - constants" then we got cells where values being
input directly into those cells.
Can Excel show me those cells with formulas involving values from other
sheet(s), as opposed to formulas involving cell values from the same sheet?

 

[Gary''s Student]

Try this small macro:

Sub find_bang()
Set r = Nothing
bang = "!"
For Each rr In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
If InStr(rr.Formula, bang) > 0 Then
If r Is Nothing Then
Set r = rr
Else
Set r = Union(r, rr)
End If
End If
Next
r.Select
End Sub