by Tom Chandler | Jun 29, 2022 | Macros, Spreadsheets
This week’s Excel VBA macro shows you how to program a cut and paste action. Three examples are shown in the image above: The first uses four statements to cut a range of cells, reposition the cursor, paste, and finally turn off the cut/copy mode. The second example...
by Tom Chandler | Feb 20, 2022 | Holidays and Inspiration, Macros, Word Processing
Presidents’ Day this year is on Monday February 21, 2022. This is the day that citizens of the United States remember the service given by Washington, Lincoln, and other Presidents of the United States. As part of my remembrance I wanted to display...
by Tom Chandler | Mar 30, 2021 | Macros
After recording a macro in Microsoft Excel or Microsoft Word, often there is a need to edit the macro. However, before being able to successfully edit a macro written in VBA (Visual Basic for Applications), one first needs to know how to read it. That is the subject...
by Tom Chandler | Mar 23, 2021 | Macros, Programming, Spreadsheets, Step-by-step, Word Processing
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...
by Tom Chandler | Mar 16, 2021 | Macros, Programming, Spreadsheets, Step-by-step, Word Processing
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...
