cNum = Application.Countif(Range("Letters"),"A")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Spencer Hutton" wrote in message
...
is there a VBA statement that can return the number of times the letter A
appears in a range named ("Letters"). this range contains only single
letter
values, A, G, M, I, P, and R. i want to count how many A's there are in
this
range. TIA.