Deleting Corrupt styles
 

Hello,

Is there any way of purging styles that can't be deleted through VBA due to
some corrupt characters embedded within the style names ? I think the
problem I'm facing may be due to the multi-national nature of my
spreadsheets, however I can't pinpoint the source language of the
corruption.

Any suggestions ?

Deleting Corrupt styles
 

Hi Steve,

Is there any way of purging styles that can't be deleted through VBA due to
some corrupt characters embedded within the style names ? I think the
problem I'm facing may be due to the multi-national nature of my
spreadsheets, however I can't pinpoint the source language of the
corruption.

Have you tried putting the workbook through a HTML roundtrip?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com