Check If A Sheet Exists in Excel Workbook Using VBA
Check whether a sheet with a specified name exists in your workbook using VBA. In this video, we look at looping through the sheets in a workbook to check whether the sheet exists.
It is important to remember that sheet names are case sensitive so it is better to convert them to either all lower case or upper case letters when doing the comparison.