Insert a Variable Row to SUM SubTotal

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Insert a Variable Row to SUM SubTotal

FAQ

Thread Tools

Display Modes

02-12-2018, 10:46 AM

jeffreybrown jeffreybrown is offline

Windows Vista Insert a Variable Row to SUM SubTotal

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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

Tags

insert sum last row

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
Each subtotal signature require only at last page for each subtotal.	aligahk06	Excel	0	05-07-2010 11:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.