Hello JIBG,

Glad you like it. I am not sure I follow what you mean with applying the function to Range. It is constructed to work with a single cell value. Can you give me an example of the range application?

The Application.Volatile statement is used in VBA macro to ensure the macro fires whenever Excel recalculates. This is used only with a UDF macro. The same macro will run in VBA. The Application.Volatile statement will be ignored.

Sincerely,
Leith Ross