Thanks Guys for all your help.
Jim, this worked fine and is all that I was looking for
Thanks again, Rob
"Gord" wrote in message
That's the one I was trying to think of<g
Brain dead Sunday............watching too much good ol' boys on TV
On Sun, 17 Jul 2011 16:18:37 -0700, "Jim Cone"
To just get the count of cells that have text, you can use...
It subtracts the number count from the count of all cells with an entry
(errors, true/false, text,