How to count non-empty cells
How does this question relate to your topic.
i = Application.Countif(Range("A1:Z26"),"<N")
j = Application.CountBlank(Range("A1:Z26"))
--
Regards,
Tom Ogilvy
"SteveT" wrote in message
...
I have a range of cells with various values (dates, letter N, letter P). I
want to count the number of cells within the range that don't have the
letter
N. I don't want to add contents, just get the number of cells that
contain a
value. Can someone tell me how this is done?
--
-----------
Thanks,
Steve
|