Counting occurrences

[GARY]

How can I determine how many equal (=) signs are in my spreadsheet?

 

[Bob Umlas, Excel MVP]

ONE way, if you're really counting formulas is to use Edit/Replace, replacing
= with x=. Excel will tell you how many it replaced. Then replace X= with =
to restore it!

 

[StumpedAgain]

Run this macro. It'll tell you the number of "=" you have in the active
spreadsheet. Hope this helps!

Sub equalnumber()

Dim i As Integer
Dim cell As Range

i = 0

For Each cell In ActiveSheet.UsedRange

If cell.Formula Like "*=*" Then i = i + 1

Next cell

MsgBox ("There are " & i & " occurences of = in this worksheet")

End Sub

 

[StumpedAgain]

oops... I see your earlier post now....