Lee’s Word Troubleshooting Guide

This is part of a series of my notes and troubleshooting guides referring to Microsoft Office. They are all listed here: Lee’s Excel Troubleshooting Guide Lee’s Outlook Troubleshooting Guide Lee’s Word Troubleshooting Guide For those looking to recover data from corrupted files, I’ll spoil it, it’s below. 🙂 Also, here’s a link to another blog…


Lee’s Outlook Troubleshooting Guide

Outlook is a product that has been around for a very long time, with its first release as part of Office 97. Amazingly, it is the youngest of what I call the “pillars of Office”, like Word, Excel, and PowerPoint. There was one deviation to Outlook, which was Outlook 98 which I believe you could…


Lee’s Excel Troubleshooting Guide

In troubleshooting various Excel issues, I have found the following solutions to work quite often. Here are my notes in troubleshooting Excel. This was intended for current version 2016, but a lot of this information is still relevant in older versions, such as 2010/2013. If you’re using something older, upgrade already. This is part of…


Excel: Subtract Minutes from Time

So, you have a spreadsheet and you’re trying to log time entries, say for work. You work 8:00 to 4:30 and get a half hour for lunch. How do you calculate this in Excel? 1. Create a spreadsheet, and put this in column A: 8:00:00 AM 2. Put this in Column B: 4:30:00 PM 3….


Excel VBA: Deleting a worksheet in code

I wanted to take a moment and share a little VBA in Excel that would delete a worksheet from code. Usually, you would want to use this as a part of a larger routine. To call the Sub, use this syntax: DeleteWorksheet “xxx”, False Where xxx represents the name of the worksheet, and False (or…


Excel VBA: Replacing text in a specific column with code

Another really quick code snippet to replace text in a specific column through code. Usage is simple: ReplaceTextInColumn “A”, “Hello”, “Aloha” Where “A” is the column to replace text in. Hello is the text to find, and Aloha is the text to replace Hello with (thinking warm this winter). You can extend this to add…