Bug-Free code is without any error codes.įor example, assume you have 100 lines of code, and you know for sure your first 25 lines of code is bug-free code. While debugging a large amount of code, we need to run through bug-free lines of codes without wasting much time. Debugging allows us to find the loopholes of the code and fix them. Why do we need to use it?ĭebugging is part and parcel of the coding in any language. In some cases, without putting the breakpoint, we can exit the subprocedure as well. When you test huge code, it takes a lot of time to step through each line, so to run fast to the next level or step of code, we can set the breakpoint and test until the breakpoint and proceed from that breakpoint line by line. When we write a considerable amount of code, we need to test those lines of codes to proceed to the next level of coding to ensure our line of code is working as per our objective. The discovery of the power of VBA comes when we write huge code to execute big projects to get the job done.