using countif function in code
 

How can I express this in VBA code:

countif(c:c,c2)

Thanks.

using countif function in code
 

MsgBox Application.COUNTIF(Columns("C"), Range("C2"))

HTH

Bob


"Bradly" wrote in message
...
How can I express this in VBA code:

countif(c:c,c2)

Thanks.

using countif function in code
 

On Thu, 4 Feb 2010 13:47:01 -0800, Bradly
wrote:

How can I express this in VBA code:

countif(c:c,c2)

Thanks.

Try something like this:

WorksheetFunction.CountIf(Sheets("Sheet1").Range(" C:C"),
Sheets("Sheet1").Range("C2"))

Hope this helps / Lars-Åke