+ Reply to Thread
Results 1 to 8 of 8

Macro Code for "ALT" + "=" sum short key

  1. 04-01-2015, 02:35 AM #1
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Macro Code for "ALT" + "=" sum short key

    It is easy to sum a column or row with ALT = keys.

    Is it possible to do this with code? To sum for columns and to sum for Rows
    Last edited by caabdul; 04-01-2015 at 07:51 AM.
    Reply With QuoteRegister To Reply
  2. 04-01-2015, 02:41 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Macro Code for "ALT" + "=" sum short key

    Quote Originally Posted by caabdul View Post
    It is easy to sum a column or row with ALT = keys.

    Is it possible to do this with code? To sum for columns and to sum for Rows
    But why would you need it when Alt + = Does the job?
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 04-01-2015, 03:22 AM #3
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Macro Code for "ALT" + "=" sum short key

    Actually I have a macro that puts numbers in column B. I don't know how many numbers it will put. May be B1 to B10 or up to B100. I just want the total of column at the end.
    Reply With QuoteRegister To Reply
  4. 04-01-2015, 04:38 AM #4
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Macro Code for "ALT" + "=" sum short key

    So basically in Column B, on the 1st Bank Cell that you find from top, you want the Total of numbers above it?

    Is that right? And is it only restricted to Column B?
    Reply With QuoteRegister To Reply
  5. 04-01-2015, 07:18 AM #5
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Macro Code for "ALT" + "=" sum short key

    Consider there are cells Starting from B1 and go down. I need total right below these cells in column B.
    Reply With QuoteRegister To Reply
  6. 04-01-2015, 07:35 AM #6
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Macro Code for "ALT" + "=" sum short key

    Here!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-01-2015, 07:49 AM #7
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Macro Code for "ALT" + "=" sum short key

    Smart solution
    Reply With QuoteRegister To Reply
  8. 04-01-2015, 07:52 AM #8
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Macro Code for "ALT" + "=" sum short key

    Glad it helps!

    Please mark the thread as Solved if you have your answer..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Short "Basic" Macro to copy and paste formulas "N" times.
    By gradyhawks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 02:34 PM
  3. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] How to short my formula which is ="("&a1&","&a2&","&a3&","&a4&" end in "&a200&")
    By vengatvj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-07-2013, 07:49 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1