Formula from other sheet(s)

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?
 
G

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
 
Top