Understanding Excel Dot Notation

Dot notation is an important part of Excel codes. You will often see it when you are developing or recording macros so it is important that you know what it means and how you can use dot notation to help you create macros faster and in a way that is more efficient.

Everything to the left of the dot is an object, and everything to the right of a dot is what you want to do with an object. For example, if you see a code that says ActiveCell.Font.Name = “Ariel” it means that you want to change the font of the current active cell to the Ariel font.

You can use dot notation for any type of code in Excel, and the better you get to know it the more complex and efficient your codes will be. Because there are practically no limits to the kinds of codes you can create in VBA, as long as you understand the language of the coding, you never have to worry about creating a code that will end up being incorrect.