ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing subtotals - annoying 'feature' (https://www.excelbanter.com/excel-programming/376822-removing-subtotals-annoying-feature.html)

Gizmo63

Removing subtotals - annoying 'feature'
 
Hi all,

I'm using the 'Selection.RemoveSubtotal' command to clear redundant
subtotals when reprocessing sheets, however it also removes any column
groupings that are in place.

Is there any way to prevent this happening?

At the moment I clear the subtotals and then replace the column groupings.

Cheers

Giz


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com