View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gizmo63 Gizmo63 is offline
external usenet poster
 
Posts: 43
Default 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