Yeah the difference is though that Chip's function only handles conditions
using the Condition Is option, mine handles that and Formula.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mwam423" wrote in message
...

hi bob, i owe you an apology. reread the white paper and per "further
enhancements" section, added "application.volatile" to CFcolorindex
formula.
now i'm able to recalc CFcolorcount, on a worksheet by worksheet basis,
with
F9 or "calculate" in code, which pretty much replicates what i had to do
with
c. pearson's countofCF formula.

my apologies and thanks for the great work!