Ungroup causes Run-time 1004 error

Hello

I'm using the following code to "reset" a worksheet, that is, clear all contents, column/row grouping etc. For some worksheets there may not be any grouping, and when I run the macro I receive a Run-time error '1004' Ungroup method of Range class failed.

Can someone suggest an appropriate "On Error Resume" code for the following code, such that if the worksheet contains data the data is cleared and columns/rows reset?

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

Thanks BigBas!

I thought an "On Error Resume Next" needed a "Next xxx" to work.

Am I correct in thinking that the "Next" actually refers to the next line or operation, and doesn't need a specific "Next xxx" after the block of code?

It is my understanding (and I could be incorrect) that it went on with the code. I think the bit of code that needs an identifier is the GoTo Error Handler, ie:

Please Login or Register  to view this content.

Thanks for explaining that BigBas. I do appreciate it and now I've learnt something!