Category Archives: Excel For Each

Excel VBA Subtotal On A Dynamic Range

Hi Reader,

This post will show you how to add subtotals on a variable group by column and total column, and it will also show you how to add some color to the subtotal rows to make them stand out.

Here is what the data to which we want to add the subtotals looks like:

and here is what it will look like after the code is run…

Here is the code:

Let me know if you have any questions.

Facebooktwittergoogle_plusredditpinterestlinkedinmail
READ MORE