If WorkSheet(“wsName”) Exists [duplicate]

by

A version without error-handling:

Function sheetExists(sheetToFind As String) As Boolean
    sheetExists = False
    For Each sheet In Worksheets
        If sheetToFind = sheet.name Then
            sheetExists = True
            Exit Function
        End If
    Next sheet
End Function

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. How can I create a calendar input in VBA Excel?
  9. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  10. Using Google Chrome in Selenium VBA (Installation Steps)
  11. Dir() function not working in Mac Excel 2011 VBA
  12. Delete a row in Excel VBA
  13. Concatenate cell data into another data if values matches
  14. Iterating through populated rows
  15. How to convert 32 bit VBA code into 64 bit VBA code
  16. Using VBA to detect which decimal sign the computer is using
  17. Loop through each row of a range in Excel
  18. Fill formula down till last row in column
  19. Outputting Excel rows to a series of text files
  20. How to create a range from two ranges in VBA?
  21. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  22. If string contains word from list, return value adjacent to list value
  23. every possible combination of the contents of 2 columns in excel
  24. excel vba freeze pane without select
  25. How to delete rows in Excel based on criteria using VBA?
  26. Converting a string representation of a constant into a constant?
  27. Function Overloading and UDF in Excel VBA
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment