Convert Array Formula into VBA User Defined Function

[hhhhwong]

I want to convert the below count & if function into a user defined function. However, its outcome is false. What's wrong with it? Can someone helps?? Thanks in advance!

Please Login or Register  to view this content.

[JosephP]

that function only tests if the current selection contains the formula specified in the code. you need to use evaluate if you want to actually calculate that formula but I am not sure what the benefit of the udf is-the formula in the cell would be more efficient

[hhhhwong]

Thanks Joseph! The reason is I want to hide my calculation. I have to let the user to know the raw data but cannot let them know to calculate it!

I have changed my code but the outcome is still "FALSE". Are there any problems?

Please Login or Register  to view this content.

[JosephP]

yes-the code is wrong and the formula makes no sense. what is the formula supposed to do?

[hhhhwong]

The code is obtained from Macro recording but it doesn't work in module.

I want to use a User defined function to replace the formula in the spreadsheet "Master Table" of the attached file.