Thread: Countif in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Hunter[_2_] Lee Hunter[_2_] is offline
external usenet poster
 
Posts: 3
Default Countif in VBA

Will someone please show me an example of using countif
as a worksheet function in VBA.

I have used the "Find" function to determine the starting
row for the countif. It is stored in a var "c"

What is the correct syntax to count the number of rows
with a "1" in column B, starting with the row "c".

Thanks for your help.