error method delete of class range has failed with Select Case

Hi,

If i run this macro i get an error message: "method delete of class range has failed" (translated from dutch), with the line

Please Login or Register  to view this content.

being highlighted. How to overcome this?

Please Login or Register  to view this content.

Perhaps, sheet(s) is/are protected?

The sheets are not protected. The columns are deleted for all the sheets except for the ones named "CD", "DGFZ", "DGRB", "DRZ", "GT".

Thank you for your response but i know what the problem is. In the "CD" sheet i have several pivottables below each other and because of that i can't delete the entire column.