Find and replace based on formula result

[Trikageon]

Hey all!

I'm looking for a bit of code that would seek out a specific value that's displayed as a result of a formula and, once found, clear those cells. For example, my formula is:

=IF($C14="Sub-total",SUMIF($M:$M,"Sum"&KK13,G:G),IF(AND(ISTEXT($F13),ISBLANK($C14)),"",IF(AND(ISBLANK($F12),ISTEXT($F13)),"Box",IF(ISTEXT($F13),"Sum",IF(ISBLANK($F14),"",IF(ISTEXT($F14),$F14,"Box"))))))

All I want to do in my macro is search-out, in a particular worksheet, when the result of the above formula is "Box" and then simply clear those cells with that result. Ideally, if I could do that within a defined range, that would be good too (G:H)!

I can find just those cells with this result using the basic "find" feature, with drop-down "values" selected, but in order to find and replace, it's only giving me the option to select "formulas" from the drop-down, which of course will then find every cell with that word in the *formula* and I don't want that...I just want to find when the result is "Box"

Any ideas?

 

[swinglow]

so instead of "Box" you want it to be nothing? Would an empty string suffice? (i.e. "")
because then you could just clear "box" out of your formulas

 

[Trikageon]

I thought about that, but I need it be blank, because it's preventing another formula from adding properly (and I don't really want a bunch of zeros). Unless you can think of a fix to the formula that's having the error:

=IF(ISTEXT(F54),F54,IF(F54="","",F54+G54-H54))

Maybe there's a way for it not to give the result "#Value!" if we changed "box" to ""?

Thanks!