I havent worked with xl07 yet, i bet that is what I am thinking about
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

Fighting Texas Aggie Class of 2009


"Max" wrote:

.. isnt there a way to check the entire column without specifing 65k.
Guess you mean using entire col references, like: A:A, B:B etc? In xl03, my
ver, sumproduct or array-entered sum will not work with entire col refs. But
I've read from posts that xl07 allows that, which makes for simpler/shorter
looking formulas all round. Albeit I'm not sure about the resultant recalc
speeds in xl07 if entire col refs were used liberally in such formulas.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---