Microsoft Office Forums - View Single Post - [Solved] Insert a Variable Row to SUM SubTotal

Thread: [Solved] Insert a Variable Row to SUM SubTotal

View Single Post

Old

02-12-2018, 10:46 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

You are very welcome. Glad it worked out for you.

Just as an aside, you can make a slight adjustment to the added part. Very rarely do you ever have to select an object.

Code:

    With ActiveCell.EntireRow
        .Font.Bold = True
        .NumberFormat = "0.00"
        .Style = "Comma"
    End With

Reply With Quote