What would cause the error handler to not work?

[natefarm]

My code opens a user-selected workbook and attempts to select the worksheet name that matches the current sheet in the original workbook. For some reason, the error handler doesn't get triggered if it doesn't find a matching sheet. I have copied the code to a new workbook, and it works fine there. Does anyone have ideas on what might nullify the error handler? In the code below, the FindSheetFailed is the one that won't work. Instead it gets a Subscript Out Of Range error if it doesn't find the sheet.

Please Login or Register  to view this content.

[Leith Ross]

Hello natefarm,

When testing objects it is a good practice to assign the object to an object variable first rather than select it straight away. This method allows you check if the object was set and prevent the system from overriding your error handler. The changes are in bold text.

Please Login or Register  to view this content.

[natefarm]

Thanks for the suggestion. Unfortunately, it didn't help. I still get Subscript Out Of Range.

[Leith Ross]

Hello natefarm,

To troubleshoot this further, I would need to see the workbook. Can you post a copy of it?

[snb]

You won't need any:
And you'd better avoid activate and select in VBA.

Please Login or Register  to view this content.