K,

Thanks for the great input. My problem was trying to put th
countall--a number--into a string. "A1:A & (countall)" "A1:A(countall)
.. i tried all of these but the correct one. Thanks K. you are th
best

--
Message posted from http://www.ExcelForum.com