It just occured to me that you may want to distinguish between cells with =
in the formula and cells with = in the value. If you only want cells with =
in the value you could change the code in my previous post from

c.Formula Like "*=*" to
c.Value Like "*=*"

Keith


"rockhammer" wrote:

Is there a way to make something like =countif($a$1:$a$100,"=") work as
intended?

The function is returning zero when there are clearly cells with the text
"=" in it. If i were to use something like $a:$a as the range, it will just
count all the blank cells in column A.

Thanks.