application.worksheetfunction. <function> (syntax)

[Peter]

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

 

[Chip Pearson]

Peter,

Try something like

MyValue = Application.WorksheetFunction.CountIf( _
Worksheets("X").Range("B2:B2000"),"*212*")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peter]

Thanks for the tip, Chip. Unfortunately I get the error Expected: Expression
when I try this.

Peter

 

[Peter]

I'm a liar, I just applied it the wrong way. How can an answer from Chip
Pearson possibly not work ?

Sorry