Some folk dislike this approach because of an “inappropriate” use of error handling, but I think it’s considered acceptable in VBA… An alternative approach is to loop though all the sheets until you find a match.
Function WorksheetExists(shtName As String, Optional wb As Workbook) As Boolean Dim sht As Worksheet If wb Is Nothing Then Set wb = ThisWorkbook On Error Resume Next Set sht = wb.Sheets(shtName) On Error GoTo 0 WorksheetExists = Not sht Is Nothing End Function
Related Posts:
- Object Required Error in excel VBA
- What are .NumberFormat Options In Excel VBA?
- Better way to find last used row
- VBA, if a string contains a certain letter
- Excel VBA Macro: User Defined Type Not Defined
- VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
- Select method of Range class failed via VBA
- Does VBA contain a comment block syntax?
- Why does “Paste Method of Worksheet class failed” occasionally occur?
- How to return a result from a VBA function
- How to clear memory to prevent “out of memory error” in excel vba?
- Use VBA to Clear Immediate Window?
- VBA: Else without If Error
- Recommended IDE for VBA
- ByRef argument type mismatch in Excel VBA
- VBA: Convert Text to Number
- VBA Error: “Compile error: Expected End Sub”
- Error: “Could Not Find Installable ISAM”
- Loop without Do error
- Row count where data exists
- How to detect if user select cancel InputBox VBA Excel
- macro run-time error ‘9’: subscript out of range
- Why does my VBA code throw an “Invalid outside procedure” error?
- Excel Solver Password: what is it and where can it be acquired/bought?
- Compile error: Next without For || VBA
- Is there a way to crack the password on an Excel VBA Project?
- MS Excel Scatterplot converts Months to Numbers
- What does <> mean?
- Excel to Google Sheets – Error: Formula parse error
- Swap x and y axis without manually swapping values
- Excel: Calculate the frequency of a particular month in a column of date cells
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- How to find a value in an excel column by vba code Cells.Find
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- Insert picture into Excel cell
- What is a correct MIME type for .docx, .pptx, etc.?
- Is there Infinity in Spreadsheets?
- Declaring variables in Excel Cells
- How to loop in excel without VBA or macros?
- What is correct content-type for excel files?
- How do I get countifs to select all non-blank cells in Excel?
- What is the function of FormulaR1C1?
- What exactly is the function of Application.CutCopyMode property in Excel
- Excel – SUMIFS for multiple columns
- Workaround for “Formula omits adjacent cells”
- VBA Excel – Insert row below with same format including borders and frames
- check if a file is open in Python
- Select all the cells below current cell in excel
- Excel: Can I create a Conditional Formula based on the Color of a Cell?
- Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
- How do I open space-delimited file in Microsoft Excel?
- Scraping data from website using vba
- Using SUBSTITUTE with wildcard characters
- Change default ‘delimiters’ in excel
- Adding a newline character within a cell (CSV)
- VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
- How to install Date Picker form control in Excel 2016
- How to install Date Picker form control in Excel 2016
- How to fill color in a cell in VBA?
- (Excel) Conditional Formatting based on Adjacent Cell Value
- Shortcut to Apply a Formula to an Entire Column in Excel
- Refreshing all the pivot tables in my excel workbook with a macro
- How to label scatterplot points by name?
- What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
- Average in VBA in Excel
- VBA Excel “Compile error: Object Required”
- Choosing paper size (NOT DEFAULT sizes) in excel vba
- “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
- Paste Special error 1004 PasteSpecial method of Range class failed
- Using Excel VBA to run SQL query
- VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
- Cannot run the macro… the macro may not be available in this workbook
- Substring in excel
- IndexError: too many indices for array
- How do I split a string on a delimiter in Bash?
- ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
- How to run a PowerShell script
- Looking for a clear description of Excel’s .xlsx XML format
- How to mkdir only if a directory does not already exist?
- Help needed with Median If in Excel
- How can I declare and use Boolean variables in a shell script?
- “[ ]” vs. “[[ ]]” in Bash shell
- VBScript to open a dialog to select a filepath
- Does VBA have Dictionary Structure?
- What is the $? (dollar question mark) variable in shell scripting?
- Bash script: bad interpreter
- Exception from HRESULT: 0x800A03EC Error
- Syntax error on token(s), misplaced construct(s)
- ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
- Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
- Python script header
- How to open an Excel file in C#?
- Shell script not running, command not found
- VBA array sort function?
- How to Clear Office Clipboard with VBA
- VBA: Run time error ’91’?
- Compare Dates in VBA
- What is the difference between double and single square brackets in bash?
- Run a .bat file in a scheduled task without a window
- How can I fully log all bash scripts actions?