I'm trying to determine how many numeric values are contained within a
range filled with many blanks. I've tried both the ISNUMERIC and the
ISBLANK code, the first just counts all the cells even the blanks, and
the second gives me an error when i run the program

Here is the code:
For C = Row To value
NotBlank = IsNumeric(range(f_column & C))
If NotBlank = True Then
NoBlanks = NoBlanks + 1
End If
Next C

Any ideas????
Thanks in advance,

dani


--
Dani
------------------------------------------------------------------------
Dani's Profile: http://www.excelforum.com/member.php...o&userid=23542
View this thread: http://www.excelforum.com/showthread...hreadid=383153