Yes. Couple of tips: use datatypes on your parameter declarations and your Function declaration, and "Range" is a (very commonly used) object in Excel so picking a different name for your function ...

This short project is a direct application of the Juan-Carlos Richard and Thierry Roncalli article available on ssrn. The cyclical coordinate descent (CCD) they describe is a fantastic tool in that ...

Este repositório contém uma biblioteca com conjunto de funções em VBA (Visual Basic) para o Excel que precisei customizar no Excel para atender minhas necessidades e acabei reutilizando com bastante ...

Is it possible to access Excel's various mathematical functions (specifically NORMSINV) from within VBA. I can sort of do what I want just by setting the value of a cell to a string like ...