On Thu, 24 Jun 2004 13:40:02 -0500, Don Guillett wrote:

maybe this ARRAY formula to be entered with control+shift+enter instead
of
just enter

=COUNT(IF(($B$1:$B$5=B1)*($A$1:$A$5),1))

no, it gives 2 as result for AA.

I think I get the point: passing data from worksheets to VBA and vice
versa is
a s-l-o-w process.

here the explanation:
http://www.avdf.com/apr98/art_ot003.html

thank you anyway
Fra