How can I determine how many equal (=) signs are in my spreadsheet?
B Bob Umlas, Excel MVP Aug 13, 2008 #2 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!
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!
S StumpedAgain Aug 13, 2008 #3 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
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
