View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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.