So OK if you want to accept this but you maybe wanted to have several different instances where you
were testing this.
You don't have to put it in the start or on the finish.
You could put it somewhere in between using an if then statement and the way to exit one of these without
saying Exit Sub is just like kind of when you do a for loop you say Exit 4 where you can say Exit do
at any point and that will in the loop and skip over to your next commands.
So if I'd said if I take off the word wow if cells X comma one is not or as is blank then I should probably
change that.
Yeah if that is blank then X it do.
And when I tap away or click away you'll see that these are blue and they're capitalized at the very
beginning so these words have some power to them in VBA.
So that's going to do the same thing.
It's going to go ahead and do.
Meaning it will start to loop regardless.
But if you want to add this hey if it's a blank then exit the loop basically you can edit it in it you
can edit it multiple stopping points if you had a whole bunch of commands in here and blah blah blah.
And if you had a whole bunch of commands in here and you wanted to test is it blank at this point.
And at this point at this point and you didn't want to have to do it only here or only here at the start
or end you could do that and you could do a lot of things like that.
So keep your creativity hats on because there's all kinds of ways to skin these cats.