using countif function in code

[Bradly]

How can I express this in VBA code:

countif(c:c,c2)

Thanks.

 

[Bob Phillips]

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

HTH

Bob

 

[Lars-Åke Aspelin]

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