CountIf in VBA

[Les Stout]

Hi,

me again, i am also wanting to scan down a column, about 4000 lines and
if certain criteria is met i need to count it in other words manually i
would use a Countif.
I would like to know if it is possible to use code to do this?
Sometimes it is also necessary to look for different criteris in
different columns, but on the same row.
If this is possible could you help me with some code ?

Les Stout

 

[Frank Kabel]

Hi Les
one way: Use
application.WorksheetFunction.countif(...)
in VBA