Results 1 to 4 of 4

Autosum Macro/built in macros

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    29

    Autosum Macro/built in macros

    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:
    ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)"
    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:
    Private Sub Worksheet_Change ()
    End Sub
    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:
    Set rngRange = .Find(What:="SUM", LookIn:=xlFormulas)
    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?
    Last edited by Gzdnkh; 06-19-2013 at 06:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1