Microsoft® Office Excel 2003 Inside Out

Going On from Here

In this chapter, you've learned how to create macros with the help of the macro recorder. As you learn more about the VBA programming language (a subject beyond the scope of this book), you'll notice that the macro recorder often creates more code for a task than you really need. In our CompanyFont macro, for example, the following lines that the recorder recorded were unnecessary because all you wanted to do was set the font name, point size, and weight:

.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic

The recorder added these lines because it didn't (and couldn't) know they weren't necessary. You can edit them out without ...