myVal = application.countif(activesheet.cells,"NPQ")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"JBW" wrote in message
...
Me again folks, sorry.

System report will be variable number of rows deep, I have macro that's
running sweetly but counter in VB is set to big number to make sure all
lines
calculated. I need to be able to count he occurences of "NPQ" in the
sheet,
this will give me correct counter number for vb.

How do I do count?
How do I refernce answer in the macro?

cheers in advance for all your wonderful help