Subtotal Mode?

[ColdDay]

I need to loop thru all the sheets in my wb. If they have been subtotaled, go to the next sheet. If they have not, then subtotal them on a specific column.

I know the looping code. It's the "How do I determine if the sheet has been subtotaled" code that I am in need of.

Thanks.

 

[AnotherHiggins]

I'd just force all Subtotals off and then build them from scratch to ensure it's built the way you want it.

Cells.RemoveSubtotal

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.