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