Autosum Macro/built in macros

[Gzdnkh]

The most common mistake I make is forgetting to check Autosums when adding a new row.
So I decided to write a macro which checks the Autosums for me.

When I recorded clicking the autosum button, or [alt + =] I got:

Please Login or Register  to view this content.

So I wrote macro which finds all the necessary values and fills in the formulas.
As far as helps go there is no "Worksheet_afterInsertingRow" event.(or is there?) so I put it in:

Please Login or Register  to view this content.

But now I have a slightly different sheet and it would be great if I did not have to rewrite everything.
I plan to roughly estimate ranges where no other sums are present then use:

Please Login or Register  to view this content.

Then pass it to "DoAutosum" procedure, which I am guessing is already "built in" in Excel.

How to access the built in macro for Autosums? Is there a list (ideally in help, I have already run out of ideas with keywords and found nothing) of other built in macros?

[AB33]

You can access excel's built-in function by using worksheetfunction or application

Please Login or Register  to view this content.

[Gzdnkh]

@AB33: I know about built-in functions, I meant "built-in procedures"(not knowing if they exist). I am sorry for the confusion.
I imagined that maybe there is a procedure, a part of some Library (I am sorry, again I do not know if it is the right word) that will accept a range as variable and create a sum, just like using autosum tool would.

[AB33]

Not as far as I know.