Sub 取消全部工作簿的筛选() On Error Resume Next Dim wb As Workbook Dim ws As Worksheet For Each wb In Application.Workbooks For Each ws In wb.Worksheets ws.UsedRange.AutoFilter Next Next End Sub
excel取消全部工作簿的筛选
最新推荐文章于 2024-11-13 17:53:03 发布
Sub 取消全部工作簿的筛选() On Error Resume Next Dim wb As Workbook Dim ws As Worksheet For Each wb In Application.Workbooks For Each ws In wb.Worksheets ws.UsedRange.AutoFilter Next Next End Sub