VBA to delete worksheets except one specific sheet

Hi, I have a workbook with More than 10 sheets with different name.

I need VBA to delete all nine sheets except one sheet named as "Master Call"

Please note: the number of sheets will be increased or decreased time to time

Hi there,

The following version will avoid an error message being generated if the "Master Call" worksheet doesn't exist - without this check the routine will try to delete all worksheets and create a "The workbook must contain at least one worksheet" error message:

Please Login or Register  to view this content.

Just a little added extra!

Hope this helps - please let me know how you get on.

Regards,

Greg M