View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Coe Robin Coe is offline
external usenet poster
 
Posts: 3
Default VBA Error Handling

In VBA I have code that accesses an Excel Workbook. The code has multiple Private Subs which is looking for various worksheets in the Excel Workbook. Should a Private Sub be looking for an worksheet that does not exist VBA returns an error and stops going through the remaining private subs. I would like to create an Error Handler that upon a Private Sub not locating a particular worksheet it exits that private sub and continues on to the next private sub without stopping the processing. Is this possible?