Sep 05 2021 03:31 AM
Hi Everyone!
Is there any tool that helps to convert Functions that already exist to VBA code that you can watch?
I am trying to find the code of "SERIESSUM(x, n, m, coefficients)" but without success.
Thank you
Sep 05 2021 04:12 AM
Most (but not all) worksheet functions have an equivalent in VBA as methods of the Application.WorksheetFunction object.
See WorksheetFunction object (Excel) and in particular WorksheetFunction.SeriesSum method (Excel)
But you cannot see the inner workings of the functions.