Dear All,

While working on various models, the users sometimes move sheets or copy formats from different workbooks leading to duplicate or junk cell styles.

Removing the same is a tedious task when the model grows in size, sheets etc.

The method of removing the same by making a an excel file .zip and editing the styles.xml is not only risky but confusing as well.

Can we have a code (efficient one, we have many which loop through sheets and ranges taking ages to complete) which finds the unused custom cell styles and deletes the same?

Thanks
Sidd