.. 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
---