That didn't quite work, but this did. THANKS! These little things can be so
frustrating sometimes. Especially when you don't work with it daily.

Worksheets(1).Cells.RemoveSubtotal

"Dave Peterson" wrote:

Can you cheat and just use all the cells in the worksheet?

Worksheets("sheet1").Cells.RemoveSubtotal

Melody wrote:

That worked. Got any idea how I can write that into a macro. I have the
remove all in the macro, just need to know how to make it select the whole
range to include the grand total line.

Thanks for your help.

"Dave Peterson" wrote:

I'd try removing those subtotals once more.

Make sure you select the entire range before you do it, though.



Melody wrote:

I have Excel 2003. I have a spreadsheet that I have run subtotals on.
However, when I do Remove All to remove the subtotals the grand total and the
+- bar is still there.

How can I get rid of all the totals in the spreadsheet including the grand
total and the +- bar on the left?

Thanks

--

Dave Peterson


--

Dave Peterson