![]() If this answer solves your problem, please check Mark as Answered. Note I left periods before each Subtotal. You can either select between each additional subtotal or These posts seem to reappear, I addressed this in one of your other posts: They aren't working because the Selection is static but the actual range is changing. Selection.Subtotal GroupBy:=3, Function:=xlSum, _ Selection.Subtotal GroupBy:=9, Function:=xlSum, _ Selection.Subtotal GroupBy:=6, Function:=xlSum, _ PageBreaks:=False, SummaryBelowData:=xlSummaryBelow Selection.Subtotal GroupBy:=1, Function:=xlSum, _ Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select ![]() Then the last (of four) subtotals goes really wrong at the end and misses breaks and adds others. Starting with the second subtotal, things go a little awry. But if I record those steps into a macro and then perform those exact same subtotals from the macro, they do NOT work correctly. When I perform multiple subtotals from within a single spreadsheet, it performs just fine.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |