application.worksheetfunction. <function> (syntax)

P

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
 
C

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
 
P

Peter

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

Peter
 
P

Peter

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

Sorry
 
Top