Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some VB that SHOULD subtotal each tab that is not equal to "Source
Data" but when I run the Macro it subtotals multiple times on the same tab instead of moving to the next tab after subtotaling. Can anyone help me straighten out my For statement? Here's the Macro: For Each ws In ActiveWorkbook.Sheets If ws.Name < "Source Data" Then _ Range("A1").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(11, 12, 13 _ , 14, 15, 16, 17, 18, 19, 20, 21, 22, 23), Replace:=True, PageBreaks:=False, _ SummaryBelowData:=True Next ws |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
Macro add row and subtotal | Excel Discussion (Misc queries) | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
A MACRO ON SUBTOTAL | Excel Programming | |||
Subtotal Macro | Excel Worksheet Functions |