ExcelBanter - Customize Subtotals

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Customize Subtotals (https://www.excelbanter.com/excel-programming/272630-customize-subtotals.html)

LC[_3_]

Customize Subtotals

Hi,

I want to know if it's possible if I can change the new
row of the subtotal such as changing the text by bolding
or italized or even changing the outline.

I have this so far:

ActiveCell.Range("A2").Select
Selection.subtotal GroupBy:=3, Function:=xlSum,
TotalList:=Array(8, 9, 10, 11, 12, 13, 14, 15, 16, 17,
18), Replace:=False,
PageBreaks:=False, _
SummaryBelowData:=True

Thanks,
LC

Dave Peterson[_3_]

Customize Subtotals

See one reply at your other post

LC wrote:

Hi,

I want to know if it's possible if I can change the new
row of the subtotal such as changing the text by bolding
or italized or even changing the outline.

I have this so far:

ActiveCell.Range("A2").Select
Selection.subtotal GroupBy:=3, Function:=xlSum,
TotalList:=Array(8, 9, 10, 11, 12, 13, 14, 15, 16, 17,
18), Replace:=False,
PageBreaks:=False, _
SummaryBelowData:=True

Thanks,
LC

--

Dave Peterson

All times are GMT +1. The time now is 03:38 PM.