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 | Jun 28, 2022 | Spreadsheets
Excel lets you apply multiple formatting features with either the mouse or the keyboard. Some keyboard shortcuts are intuitive, such as Ctrl B for Bold and Ctrl I for Italics. Some keyboard shortcuts are not intuitive. For example, Alt HFK decreases the font size. As...
by Tom Chandler | Feb 28, 2022 | Spreadsheets, Step-by-step
Ever wonder “How do I create a simple and easy to use PivotTable?” PivotTables are tools you can use in a spreadsheet to quickly create interactive summary reports (tables) from raw data. Because they are interactive, PivotTables allow you to easily do...
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...
by Tom Chandler | Mar 9, 2021 | Macros, Programming, Spreadsheets, Step-by-step, Word Processing
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...
