Thanks for the suggestion Dave - I wish I had better results...I got "Object
doesn't support this property or method" as an error.

Anyone else have other ideas ?

Thanks !


"Dave Peterson" wrote:

maybe...

with worksheets("working data")
iteration = Application.CountIf(.Range("A1:K" & rcount + 1), _
.range("B" & rowx))
end with




Eric @ BP-EVV wrote:

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 !

--

Dave Peterson