PDA

View Full Version : [SOLVED] Subtotals



austenr
06-03-2005, 01:55 PM
I am using the following code to do subtotals on column C in a worksheet. I want to make the cell in column D bold like the cell in column C when it finds a change in that column. For example,


SAM JONES TOTAL: 8000

What it should be:


SAM JONES TOTAL: 8000


Selection.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(4), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True


Thanks