MrExcel Publishing
Your One Stop for Excel Tips & Solutions

remove subtotal problem - very strange ??


Posted by adam on February 26, 2001 9:49 AM

I have a macro that removes subtotals to a data range.

For some reason it is removing the bracketted subtotal structure but the TOTAL rows are not deleted.

So i have regular data but these extra rows are there. I believe that I have done this before and the subtotalled row automatically are removed.

I cant understand why this is happening.

Thanks in advance for your help.

AK


Posted by David Hawley on February 27, 2001 3:20 AM


Hi Adam

This does happen if there is a blank row before your Subtotal "Grand Total". Before select Subtotal from the Data menu to "Remove All", highlight all your columns first.


Dave

OzGrid Business Applications