EXCEL单元格格式太多怎么办
1、解决方法:在VBA编辑器里,新建模块,复制代码如下:Sub deleteStyles()Dim s As StyleOn Error Resu罪焐芡拂me NextFor Each s In ThisWorkbook.StylesIf Not s.BuiltIn Thens.DeleteEnd IfNextMsgBox "运行结束"End Sub

1、解决方法:在VBA编辑器里,新建模块,复制代码如下:Sub deleteStyles()Dim s As StyleOn Error Resu罪焐芡拂me NextFor Each s In ThisWorkbook.StylesIf Not s.BuiltIn Thens.DeleteEnd IfNextMsgBox "运行结束"End Sub