SERIESSUM function in VBA

Copper Contributor

Hi everyone
I am looking for the "SERIESSUM " function but as a VBA code.
Does someone know where can I find it?

4 Replies

@AvivSH 

 

Application.WorksheetFunction.SeriesSum

 

See WorksheetFunction.SeriesSum method (Excel) 

Thank you for your help Hans
but I couldn't find the code there.

@AvivSH 

Do you mean the code behind SeriesSum? Microsoft does not publish the source code of Excel's functions.

@AvivSH no need to know the code of SERIESSUM, it is a math function of excel, google sheets, open office, and libre office. YouTube has videos about SERIESSUM for trigonometric functions, hyperbolic functions, Legendre Polynomials, Bessel Polynomials, BESSELJ, BESSELI, Chebyshev Polynomials, Hermite Polynomials and Laguerre Polynomials. It can be used to generate Pascal Triangle Coefficients using COMBIN, COMBINA, and PERMUTE functions.