{"version":"1.0","provider_name":"My Blog","provider_url":"https:\/\/vbastring.com\/blog","author_name":"admin","author_url":"https:\/\/vbastring.com\/blog\/author\/admin\/","title":"Excel VBA Subtotal On A Dynamic Range - My Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"3NKaJDPO1X\"><a href=\"https:\/\/vbastring.com\/blog\/2019\/09\/26\/excel-vba-subtotal-on-a-dynamic-range\/\">Excel VBA Subtotal On A Dynamic Range<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/vbastring.com\/blog\/2019\/09\/26\/excel-vba-subtotal-on-a-dynamic-range\/embed\/#?secret=3NKaJDPO1X\" width=\"600\" height=\"338\" title=\"&#8220;Excel VBA Subtotal On A Dynamic Range&#8221; &#8212; My Blog\" data-secret=\"3NKaJDPO1X\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/vbastring.com\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"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: [&hellip;]","thumbnail_url":"http:\/\/www.vbastring.com\/blog\/wp-content\/uploads\/2019\/09\/VBA_SUBTOTAL_BEFORE.png"}