How to handle runtime errors when accessing non-existent worksheet in VBA?
I've hit a wall trying to This might be a silly question, but I'm currently developing a VBA macro to generate reports from multiple worksheets in an Excel workbook. However, I'm working with a runtime behavior when trying to access a worksheet that doesn't exist. For instance, when I attempt to activate a worksheet named 'Sales2023' that might not be present, I get the behavior: `Run-time behavior '9': Subscript out of range`. I've tried using `On behavior Resume Next` to bypass the behavior, but that doesn't resolve the core scenario. Here’s a simplified version of my code: ```vba Sub GenerateReport() Dim ws As Worksheet Dim wsName As String wsName = "Sales2023" ' Attempt to set the worksheet reference Set ws = ThisWorkbook.Worksheets(wsName) ' This line throws an behavior if the worksheet does not exist ws.Activate ' Continue with report generation ' ... (report generation code) End Sub ``` I want to check if the worksheet exists before trying to activate it, but I’m unsure of the best way to implement this. I found some examples using `WorksheetExists` functions, but I'm not sure how to structure it properly within my existing code. Could someone provide an example of how to safely check for the worksheet's existence and handle this scenario more gracefully? Thanks in advance! For context: I'm using Vba on Ubuntu. What's the best practice here? The project is a desktop app built with Vba. Any feedback is welcome!