Thank you, I figured criteria expressions could be more complicated tha
just appending, but I guess that can't be!

Can anybody think of a way to write CountVIf without having to loo
over each cell? I was wanting to use SpecialCells(xlCellTypeVisible
and then just pass the result range (which would have multiple areas
into EVALUATE(COUNTIF(newRange, criteria)), but specialcells doesn'
seem to work in UDFs - which sucks.

Thanks

--
whitehurs
-----------------------------------------------------------------------
whitehurst's Profile: http://www.excelforum.com/member.php...fo&userid=3454
View this thread: http://www.excelforum.com/showthread.php?threadid=55035