Dear all,

What would be the correct syntaxis if wanted to use the outcome of the
worksheetfunction countif in a range that goes from b2 to b2000 on a sheet
named "X" and the outcome should contain the number of cells that contain
the value 212.

I think it would look a little like this

MyValue = Application.WorksheetFunction.CountIf( range , "*212*" ).

Simply recording a macro that places the countif-function directly into a
cell with all arguments required for my goal does not work.

Thanks for your help

Peter