Test if subtotal exists

How can one test if a subtotal exists within a range.?

at the start of a macro i select a range and remove the subtotal.

However the subtotal may or may not exist and if it doesn't then it errors out.

HOw can test if the subtotal exist and if it does then remove it.?

Please Login or Register  to view this content.

thanks