Results 1 to 4 of 4

Thread: How do i do autosum in excel

  1. Feb 22nd, 2005, 05:33 AM #1
    machinist
    machinist is offline

    Thread Starter
    Member
    Join Date
    May 2004
    Location
    Where i am
    Posts
    38

    How do i do autosum in excel

    How do i do autosum in excel i tried recording it but i got

    Range("J22").Select
    ActiveCell.FormulaR1C1 = "=SUM(R[-20]C:R[-1]C)"

    But the range i have to add changes in size could anyone help???
    Reply With Quote Reply With Quote
  2. Mar 19th, 2005, 06:13 PM #2
    llkhoutx
    llkhoutx is offline
    Junior Member llkhoutx's Avatar
    Join Date
    Jan 2005
    Location
    Houston, TX
    Posts
    19

    Re: How do i do autosum in excel

    Just dynamically build the range, i.e.


    ActiveCell.FormulaR1C1 = "=SUM(R[-" & AComputedValue & "]C:R[-" & AnotherComptedValueOR1" & "]C)"
    Reply With Quote Reply With Quote
  3. Mar 25th, 2005, 11:49 PM #3
    ZeBula8
    ZeBula8 is offline
    Fanatic Member ZeBula8's Avatar
    Join Date
    Oct 2002
    Posts
    548

    Re: How do i do autosum in excel

    Could always use a more simple approach like this:


    ActiveCell.Formula = "=SUM(C2:C6)"
    Reply With Quote Reply With Quote
  4. Nov 16th, 2011, 01:32 PM #4
    jobs_arghya
    jobs_arghya is offline
    Addicted Member
    Join Date
    Mar 2005
    Posts
    174

    Re: How do i do autosum in excel

    Suppose the range i had to add is A2:BA2 then wheather tha same formula is applicable.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width