Hey guys, welcome back. So in this video we're going to discuss the width statement in Excel VBA. So the width statement in Excel VBA is a statement that allows you to save a bit of space and a bit of code typing or keystrokes on your keyboard. It doesn't give you any extra functionality so it's not like if you don't use it you will be missing anything is just save some time and keystrokes. So basically, the width statement allows you to apply different methods and properties to a certain object that you choose to use with the width statement. So let's say here I'm going to add the value of 52 range a one to 271 and then I'm going to make the font bold.
I'm going to make it Italic and I'm going to make it size to be 12. So if you run this macro that is gonna hop in here in cell A one you can actually do all these actions using the width statement as well. So the structure of the width is basically with and then range a one. So we want to do the same thing using the width statement. So with range a one and don't forget to write the end width, because this marks the end of the actions that you're going to do to your object. So with that particular object, you're going to start writing what you want to do with it.
Okay, so we're going to start writing the methods and properties that you want to take actions with. So basically, dot value. And you can see here that the IntelliSense for VBA is working the autocomplete feature in VBA is working because it's understanding that this is a width statement. I'm trying to do stuff to the objects. So dot value equals 50, and then dot font dot bold equals true and then dot font dot italic equals true as well. And then dot font dot size equals 12.
So this with statement is going to accomplish the same thing as these statements. And notice here that I've actually indented my code a bit. So I've indented what's between the width and the end width by actually hitting tab on my keyboard. So if I actually press enter here on the beginning of the line, if I want to indent that line a bit, I press tab on my keyboard, okay, and I'm just indenting it for readability. So this does not affect the execution of your code or anything is just affects the readability. It makes it more readable.
It gives you the sense or the feeling that these actions here that I'm taking on that object are between this width and this end width statement. They are enclosed inside it. So it just makes your code more readable doesn't affect The execution of your code. So I'm actually gonna highlight the previous code, and I'm actually gonna comment that code. So I'm gonna comment all the block of code so that it wouldn't be executed. And then I'm actually gonna delete the contents of that.
So I'm going to clear everything, so clear value on formatting and everything. And then if I execute that code, you can see here that we've done the same thing, basically. So this width statement allows you to do the same thing as the above four lines of code, except that you do it with less keystrokes. So if you don't use the with statement, you will not be missing any functionality. It's just that you're going to save some keystrokes when you use it. So that's it guys for the width statement.
Thank you very much for watching this video and I'll see you on the next one.