excel - VBA - Call function inside a sub (module) - Stack Overflow

Actually, if you have that function inside of a module, you can directly reference it inside a worksheet cell, pretty much as you do with Excel's formulas.

stackoverflow.com