AutoFilter '取消筛选Sheet1.Select '将其中的sheets拆分为多个Excel文件For Each sht2 In Sheets If sht2.Name <> "明细" Then sht2.Copy ActiveWorkbook.
確定! 回上一頁