O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Macro Subroutines

Suppose you're creating a complex macro and you discover that, among other things, you want the macro to perform a task you've already recorded under a different name. Or suppose you discover that a task you've recorded as part of a macro is something you'd like to use by itself. In our CompanyAddress macro, for example, it might be nice if we could quickly and easily apply the font formats of the company name to other items in a worksheet.

With VBA, you can conveniently divide large macros into a series of smaller macros, and you can easily string together a series of small macros to create one large macro. A macro procedure that is used by another macro is called a subroutine. Macro subroutines can simplify your macros because ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required