Answers for "How To Check If A Worksheet Exists Using VBA"

VBA

0

excel vba test if worksheet exists

Function WorksheetExists(pShtName As String, Optional pWb As Workbook) As Boolean
    Dim sht As Worksheet

  If pWb Is Nothing Then Set pWb = ThisWorkbook
    On Error Resume Next
    Set sht = pWb.Sheets(pShtName)
    On Error GoTo 0
    WorksheetExists = Not sht Is Nothing
End Function

Posted by: Guest on January-31-2021

Source

Code answers related to "How To Check If A Worksheet Exists Using VBA"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#