Range("B65").Value = application.CountA(range("B5:B62"))

--
Regards,
Tom Ogilvy


"Kelly********" wrote:

Can some one get me started in the right direction to look at colunm (B) If
name is present add how many names are in colunm B in cell B65. (Note I only
may have a name in B5 thru B62)