+ Reply to Thread
Results 1 to 2 of 2

subtotal up to blank row

  1. #1
    Forum Contributor
    Join Date
    11-01-2012
    Location
    NJ
    MS-Off Ver
    Excel 365
    Posts
    109

    subtotal up to blank row

    Hello,

    I have a macro that I need to subtotal from current active cell up to first blank cell. Problem is that the range of the sum will change from month to month. Some months lines L98 thru L108 and next month could be L105 thru L126

    Any help would be appreciated!

    Thank you!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: subtotal up to blank row

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert blank changing colored row on column cell change and then subtotal
    By joyglobal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-25-2014, 03:44 AM
  2. Macro to create sub total as also inserting blank rows after each subtotal
    By nilankar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2013, 07:26 AM
  3. [SOLVED] Insert Blank Rows between sorted projects, Subtotal project to the right of final project.
    By ZAC7 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2012, 04:08 AM
  4. Replies: 8
    Last Post: 07-31-2012, 09:41 AM
  5. Subtotal - Delete zero Subtotal and prior rows that calculate to that zero Subtotal
    By Whatsherface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 08:37 PM
  6. Macro to compare two cells, insert blank line, subtotal
    By odiebai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2010, 11:01 AM
  7. fill in blank cells after Grouping Subtotal
    By sj2487 in forum Excel General
    Replies: 8
    Last Post: 08-31-2009, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1