[SOLVED] Delete Subtotal if It Exists

TMS Thank you for the reply.

I'm no longer receiving the error message but the subtotals are still in place.

When I used macro recorder initially do this I was given the following code:

Please Login or Register  to view this content.

My code is:

Please Login or Register  to view this content.

I do notice that when I run the macro recorder and I manually do it, an error message pops up after which requires me to hit okay.

It says, "Microsoft excel cannot determine which row in your list or selection contains column labels, which are required for this command. I hit okay. And then I just click remove all on the subsequent subtotals window.

Does that come into play when writing this?

Tried the below code and it works to get rid of all the data in columns A through J but still doesn't do anything with the subtotals unfortunately.

Please Login or Register  to view this content.

Also tried doing it like this:

Please Login or Register  to view this content.

Ended up with the same results in each case, deleted the data properly but didn't do anything with subtotals.

TMS-

Thanks for reply. I have no idea why this worked but it did. I went to create a sample workbook to show the issue I was having and it ended up working. It seems the following code works:

Please Login or Register  to view this content.

May it has something to do with using cells. instead of a column range. In any case, I'll mark this thread solved.