Sharing Macros

Sharing Macros

Our mothers taught us that you should share. Why? Because she said it would make us good play mates, would help our friends, and it would help keep peace in the home. Now that we are all grown up, we find the same is true in our organizations and with our macros. You...
Testing Macros

Testing Macros

The final step, before sharing a macro with others, is testing. Why? Well, would you buy a car without giving it a test drive? Of course not. Similarly, you need to know that your macro is going to work before you put it into production. This blog post covers how to...
How to record a macro

How to record a macro

This is the third article in a series about creating macros in Microsoft Excel and/or Microsoft Word. The first article, What is a macro? Defined what a macro is and how it can save you from having to do hours of tedious, repetitive work. The second article, Plan your...
Plan your macro or else …

Plan your macro or else …

Your mother is probably the first person to tell of the importance of planning. Mom was right. So was the Boy Scout Troop leader who told you to “be prepared.” Similarly, you were taught about the need for planning and preparation from many historical figures and...
What is a macro?

What is a macro?

I hate doing tedious work. Why should I spend minutes or even hours repeating the same action over and over again? If I can find a way to get the computer to do the work, I will. In programs like Microsoft Excel, Word, and PowerPoint, a macro is that way. Technically...