From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Implementing error-handling routines with Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Implementing error-handling routines with Copilot
- [Instructor] Great work making it to the final chapter. Here, we'll explore some essential final skills to ensure your Excel automation stays reliable and future-proof. To get started, we'll tackle error handling. As a side note, we've already touched on this idea indirectly while debugging macros, or handling tricky data situations, even if we didn't explicitly call them error handling at the time, but now let's address this head-on with a practical example. To follow along, open your workbook, Error Handling. You've got a straightforward sales dataset organized into Excel tables across multiple worksheets. The current VBA macro in the workbook is meant to export each worksheet individually into separate CSV files, but when I run it, it crashes toward the end of the workbook. There's a blank worksheet, and a hidden worksheet at the end of this workbook, which might be the issue here. So let's see if Copilot…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.