MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count Function in Formula occurances


Posted by Eric Begg on February 05, 2002 7:26 AM

Is there a quick way to count the number of times a particular formula occurs in a worksheet. I am using an Excel add-in and it would really help to know how many times a particular function appears in a worksheet, but I fear I am treading into some deep VBA waters.


Posted by Excel Prince on February 05, 2002 8:08 AM

If you want a quick way of manually checking, use Find & replace, replace it with ZZ099, and then replace it back again. The first time you do it should show you how many replacements were made.

Posted by Excel Prince on February 05, 2002 8:09 AM

If you want a quick way of manually checking, use Find & replace, replace it with ZZ099, and then replace it back again. The first time you do it should show you how many replacements were made.

Posted by Eric Begg on February 05, 2002 8:19 AM

I tried this method and Excel does not tell me how many occurences it is replacing, it just performs the find and replace.