And if he *does* want to sum them, he can use SUMIF <g.


On Thu, 24 Jul 2003 03:38:53 -0700, "Nick" wrote:

Thinking about it if you only want to count the number of
cells rather than sum them you should use

application.worksheetfunction.countif


-----Original Message-----
Hi
What code should I write in order to count only the
positive value of a
pre-defined range: Range(Cells(42, 2), Cells(77, 2))

Thanks
Pedro


.