I think it's going to be beneficial to your education for you to learn how do the following things:

1. "Step through" code (using F8 or the button in the VBA IDE)
2. Setting breakpoints (using F9 or the button)
3. Hovering over variable while stepping through code (that will tell you what their value is)

Later, you can get into using watches... but for now, I think you're going to be able to solve a bunch of your own conceptual problems just by being able to step through your own code, and trouble-shoot real time.

It can be daunting for anyone to click a button hoping your macro works. And then trying to wade through all the code to figure out what went wrong.

The solution is to step through your code, and watch it go wrong, then adjust right then and there, and run that particular line again.