Calling build in functions from user functions 1

[KaiDaniel]

Hello,

I want to write my own function that uses the result of a standard function of Excel (e.g. SUM, WEIBULL,...).
This means I want to call a function, you normaly call on your spreadsheet like this: =SUM(1;2;3)
But I want to do it from within my own VBA function.

Does anyone know how to do this.
Thanks for your help.
Kai.

 

[TonyJollans]

Hi KaiDaniel,

Use the WorksheetFunction Property. SUM is a rather pointless one to use but as an example ..

Application.WorksheetFunction.Sum(1, 2, 3)

.. returns 6.

Enjoy,
Tony

 

[KaiDaniel]

Thanks, Tony.

Kai.