vba subtotal

  1. J

    Why is my formula not working for the subtotal?

    Selection.EntireRow.Delete Worksheets("SalesComparison").Range("DC2") = WorksheetFunction.Subtotal(9, Range("dc4:dc" & Rows(Rows.Count).End(xlUp).Row)) Worksheets("SalesComparison").Range("Dd2") = WorksheetFunction.Subtotal(9, Range("dd4:dd" & Rows(Rows.Count).End(xlUp).Row))...
  2. C

    VBA for Subtotal and Copy/Paste with variable ranges

    I'm trying to figure out excel VBA code to add subtotal (=SUBTOTAL(9,__:_) formulas to multiple Total Rows within a worksheet (red boxed. The issue is that the range for the subtotals can be any height. Per the image below, the hope is that the VBA code would be able to identify when "Total" is...
  3. C

    Sorting on column a,b,c,& subtotal on 2 criteria on multiple columns

    Dear Sir, SUBJECT:- REQUIRE VBA MACRO FOR SORTING-& THEN SUBTOTAL - “A” COLUMN WISE , THEN BY “B” COLUMNS WISE WITH GRAND TOTAL -ALSO EXPAND & COLLEPS BUTTON ON LEFT OF SHEET I have a an excel sheet with data BASIC SINARIO OFANY WORKSHEET WHEN READY TO PROCESS A1 to end of “A”...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top