+ Reply to Thread
Results 1 to 4 of 4

Makro to autosum the values above and format the cell but...

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Mariehamn, Finland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Makro to autosum the values above and format the cell but...

    but the autosum should only include the cells in the column above it up until it reaches a blank cell. It sounds embarrasingly easy but I have absolutely no idea how to do it and I understand VBA about as much as I understand my wife. (I did try to search but only found an unanswered post) I would very much appreciate any kind of feedback!

    BR
    Krister
    Finland

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,262

    Re: Makro to autosum the values above and format the cell but...

    Do you need VBA or will a formula do?

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Mariehamn, Finland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Makro to autosum the values above and format the cell but...

    Hi and thanks for replying!

    I suppose a formula would be easiest!

    Thanks in advance!

    Krister

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Makro to autosum the values above and format the cell but...

    Hi kitte

    This is pretty straightforward in vba. If the Formula approach doesn't work let us know. If you wish it tailored to your file then...

    Please attach a file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not).
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

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