I'm automating a customer statement and need some help with formatting subsections. I have two code sets that each gets me almost there. Which one do you think is better, and can it be tweaked to do what I'm needing?
This first one (Macro2 in Sample File) does exactly what I want it to do, but only for a fixed number of rows. If I have extra rows it gets caught up on syntax. Can this code be adjusted to go to LastRow?
Also, it adds rows at the top, and I'd like it to not do that.
![]()
Please Login or Register to view this content.
This second one (Macro1 in Sample file) accounts for the variable rows, and doesn't add rows at the top. But I'd need it to add two blank rows under each subtotal, and I need subtotals for each column from I to LastColumn.
![]()
Please Login or Register to view this content.
Thanks!!
Bookmarks