Given that the dynamic range name def uses COUNTA() on colC instead of COUNT()
on colB, it deviates from the logic of the Contextures example.

Since this project was (obviously) derived from a copy of the Contextures
sample file, someone deliberately modified the name def[s] from the sample to
not use helper colB; -this defeats the intent use of the sample, making
ancilliary calcs more complicated than need be.

I recommend reverting the name defs back to the original Contextures example as
my linked file is done.
HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion