Okay guys, so another way to handle the errors that is more sophisticated than just ignoring them is actually using the on error go to statement. So with the on our go to statement, you can create a point that you can go to in case that there is an error. So for example here on our code, let's say we have this line of code here worksheets my worksheet, select this line of code will create an error a runtime error because we don't have a worksheet that is called Magdeburg sheet that exists in this workbook. So I've got here this statement is written before it on error go to create my worksheet, so it will go to this point here called create my worksheet in case of having an error. So on this point, called create my worksheet we need to have some code to handle the error.
So for example, we can create that particular worksheet that is called my worksheet. So you could write worksheet sheets dot add, and then active sheet dot name is equal to my worksheet. This is one way of doing it. This is one way of creating a new worksheet. There's also another way is worksheet dot add dot name is equal to my worksheet. So if we run this code this way is step through it step by step here.
So I'll start running the code here, we're gonna run this line of code here that is going to throw an error. So what's going to happen because of the error, we're going to go to the part here for creating a new worksheet. So we're going to go to create my worksheet and if you execute that, you can see here that a new worksheet has been created this called my worksheet. So this is a way of handling the error in case the worksheet does not exist. We're going to go to create it, okay, so this way your code would not throw an error. Okay, so let's say that I have more code actually after selecting my worksheet after the line of code for selection.
The worksheet called my worksheet. So let's say I'm going to put in cell 81. I'm going to put today's date. And now let's say that this line of code has failed. So I'm going to go to create the sheet. So what if I want to resume executing the lines of code after the one that's caused the error, we can actually write the line of code resume next.
So resume next will actually go back to the line of code that's caused the error, but it will not execute it, it will execute any line of code after so it will start executing any lines of code after the line of code that's caused the error. So now I'm going to delete this worksheet here called Molly worksheet. I'm going to go back to my Visual Basic environment. And let's start executing the code step by step here. So on our go to create my worksheet, and then you can see here I'm going to execute this line of code which is going to throw an error. So we're going to go to create the world worksheet.
So I've created it Now watch what happens when I execute the resume next line of code here, it will go and execute any lines of code after the one that's caused the error. So here, we're going to execute this one here, that is going to put today's date in cell A one. Now if we execute the following line of code a will actually go and execute the line of code for adding a new worksheet called Molly worksheet, which is going to cause an error because we already have a worksheet called my worksheet. So in this case, we need to exit the macros it's better to write exit sub here after I've done what I wanted to do, and put my date in cell A one if I don't want to do anything more, I'll just exit the macro Okay, so it's better to do this way.
If we delete the worksheet called my worksheet and start executing our code again, here, we're gonna select the worksheet called my worksheet and it doesn't exist. So we're going to create a worksheet called my worksheet and then resume Next, put the date and then exit the macro. So this is a more advanced way than just ignoring the errors. To use the unaired go to statement and use the resume next statement here in case we want to go back and execute any lines of code after the one that's caused the error. Okay, so thanks guys for watching this video. I'll see you on the next one.