VBA 检查表名称是否存在

HenryZ 2021-04-16 更新于 2022-11-15

Function ExistSheetName(name As String)
    Dim sht As Worksheet
    For Each sht In Worksheets
        If sht.name = name Then
            ExistSheetName = True
            Exit Function
        End If
    Next
    ExistSheetName = False
End Function

推广：阿里云百炼大模型 9折优惠 + 所有模型各百万免费Token →