don't think I am copying the code correctly. I cannot get the formula to work in my working spreadsheet. I get ###### as a result.

I am going to Developer > Visual Basic > Module1_UDF > View Code then copy the code inside the box. not sure about about "Option Explicit" I don't see that. what am I missing?