showing BOTH subtotal sums and count on excel sheet

• • Reply

  14 years ago

  by kwwm

  karen mcavoy

  , United States

  Joined 14 years ago

  I know how to place the subtotal sums or the subtotal count on the subtotal line in the excel worksheet.  However, I need BOTH figures.  How do I change the following code to print out both subtotals on the same line?

  Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5), _
          Replace:=True, PageBreaks:=False, SummaryBelowData:=True
           Selection.FormatConditions.Delete
      Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
          "=RIGHT($A1,5)=""total"""
    
  
  
  
  
  

  Thx,--kwwm

  Report abuse