preseb
04-14-2011, 06:16 AM
After I run my subtotal:
Range("A:O").Subtotal GroupBy:=2, _
Function:=xlSum, _
TotalList:=Array(9, 10, 11, 12, 13), _
Replace:=True, _
PageBreaks:=False, _
SummaryBelowData:=True
ActiveSheet.Outline.ShowLevels RowLevels:=2
How can I pull the character in column 3? I was hoping in include in the subtotal and then just replece the subtotal with an offset, but I could not get that to work.
Here is what the first subtotal looks like if I am subtotaling column 3: =SUBTOTAL(9,C2:C86) - all of those cells contains the same 1 letter character. I want to pull that down to the subtotal line.
Suggestions?
Range("A:O").Subtotal GroupBy:=2, _
Function:=xlSum, _
TotalList:=Array(9, 10, 11, 12, 13), _
Replace:=True, _
PageBreaks:=False, _
SummaryBelowData:=True
ActiveSheet.Outline.ShowLevels RowLevels:=2
How can I pull the character in column 3? I was hoping in include in the subtotal and then just replece the subtotal with an offset, but I could not get that to work.
Here is what the first subtotal looks like if I am subtotaling column 3: =SUBTOTAL(9,C2:C86) - all of those cells contains the same 1 letter character. I want to pull that down to the subtotal line.
Suggestions?