passing variable?

Hello!
I want to make a udf function in VBA to count something from a range of cells. This is the code:

Please Login or Register  to view this content.

I get the error "#VALUE!" when I enter the formula (like this: =NrOreProgram(B2:N2) ) in a cell.Can you help me please? Thank you for your time!

What's the purpose of the Function, it loks like you are trying to enter a countif function into a cell.

Your formula has an extra bracket at the end, but it will still error.

Funtions return values, they don't write to cells.

With this function,

Please Login or Register  to view this content.

putting = NrOreProgramNormal(B2:N2) in a cell will return the desired value.

It's the equivilant (even though slower) to putting COUNTIF(B2:N2,"P") in the cell.

What are you trying to do? It may be that a function is not the way to acheive your goal.