Trouble with custom function that replicates a worksheet formula

Good morning -

I'm trying to replicate a worksheet formula using VBA code. In short, I want to call a custom function to generate the same result I get with the worksheet formula. See may attached sample workbook which illustrates what I want to do.

Thanks,

Hi, what if you amend your code a little like this:

Please Login or Register  to view this content.

Cheers
Erwin