I'm trying to use the following function in VBA:

=COUNTIF(B2:B2005,B14)

Where B2 will never change, B2005 is determined by the following code:

Application.WorksheetFunction.CountA(Worksheets("w orking
data").Range("A1:A65536"))

and B14 is the column B and the current row of a table.

I have tried :

iteration = Application.WorksheetFunction.CountIf(Worksheets(" working
data").Range("A1:K" & rcount + 1), "B" & rowx)

where rowx is predefined as 2, and incremented by 1 each time a go through
the loop....but al I get back on this is a big - fat - zero.

What am I doing wrong ?

Thanks !