Can this code be shortened?

[zookeepertx]

I've got this really long macro that does exactly what I want, but a large chunk of the code at the end seems repetitive to me. But it was the only way I could figure to do what I need. I'm just wondering if some of it could be consolidated.
I'll attach my practice workbook with a sheet before the macro runs at all, a second sheet where I've only run the macro to just before the repetitive part and a third sheet showing after the whole macro runs.
Basically, what I have it doing is adding a total at the end of each section in "Account Activity Details", then adding a formula in H & I of the "Grand Total" row to sum up all of the section totals. Then, just below that, it adds a formula in I to sum up those totals. I had to designate the start of each section, then refer to the cells before or after them to tell it where to put the section totals. I can't refer to specific row numbers, because, naturally, the reports are different lengths each month.
If this is already a good way to do it, then I'm fine with that, but if there's something more efficient, that'd be good too.
Below is that part of the code:

Please Login or Register  to view this content.

Thanks!

Jenny

[Tinbendr]

While you can write more sophisticated code, in the end, it all comes down to whether you can understand it. If you compact this code, the come back to it a year later for modification, are you going to be able to understand it? A lot can be said for K.I.S.S.

[gets down off soapbox]

So, my suggestion is only to do away with all the Withs.

Please Login or Register  to view this content.

Oh, and I'd add a comment for each one of these, just to spell it out.

[zookeepertx]

While you can write more sophisticated code, in the end, it all comes down to whether you can understand it. If you compact this code, the come back to it a year later for modification, are you going to be able to understand it? A lot can be said for K.I.S.S.

[gets down off soapbox]

So, my suggestion is only to do away with all the Withs.

Please Login or Register  to view this content.

Oh, and I'd add a comment for each one of these, just to spell it out.

LOL - yeah, that's true! Although I'd probably have no trouble figuring it out, somebody else might be looking at it for some reason & have no clue what's going on.

I thought I needed the Withs; glad to be able to remove them! It looks MUCH better without those. Thanks!

Jenny