阅读背景:

如何使用VBA删除工作簿中的空白表?

来源:互联网 
Sub delete()
    Dim sh As Worksheet, wb As String, c As Range
    wb = InputBox("work book name")
    Set sh = Workbooks(wb).Sheets
        For Each Sheet In sh
            If IsEmpty(sh.UsedRange) Then
            sh.delete
            End If
        Next
End Sub
Sub delete()
    Dim sh As Worksheet, wb As Str



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: