Summary Okay, so this may be a bit weird for a blog post, but my mind was blown when I saw this. An extremely nice gentleman by the name of Jordan Webb of EXOS showed me this. More proof that you can learn anything, anywhere, anytime, from anybody. Thank you Jordan!! The examples used here [...]
Returning a web query can be very handy. Unfortunately if you want to run any code when this refreshes, there's no native way to do this. We can, however, create an event for this with a few short steps. This will all be done inside the Visual Basic Editor (VBE). To get there click [...]
Need: Do you have the need to delete duplicate emails from Microsoft Outlook? Perhaps you have accidentally created hundreds of duplicates, and your pst file is so vast you do not have the time nor the energy to remove each of them manually. In this case it would be nice to have an Excel Macro [...]
Excel Retains Manual Calculation There is a known issue with Excel's calculation when switching out of Automatic calculation mode. For those who don't know, let me recap the issues: The first workbook opened will use the calculation mode of its last save Any workbook created will inherit the calculation state of the first opened [...]
There's a new add-in for Excel called Data Explorer. Currently it's in preview (beta), so use at your own discretion and risk. What is it? Well the name really does say it all – it lets you explore data. Think of the current mechanisms we have in Excel for getting data (that doesn't require [...]
This is applicable to Excel 2007-2013. Styles are wonderful, and I've loved having them in Excel. If you're not familiar with styles, check out these links: http://office.microsoft.com/en-us/word-help/style-basics-in-word-HA010230882.aspx (Word 2007+) http://office.microsoft.com/en-us/word-help/all-about-themes-quick-styles-cell-styles-and-background-styles-HA010178624.aspx (Excel 2007+) http://office.microsoft.com/en-us/excel-help/using-styles-in-excel-HA001110199.aspx (Excel 2003) Often times, especially when sharing files, perhaps emailing files back and forth to/from co-workers, a file can become [...]
This was written with Excel 2010 in mind, but will work in 2007-2013. Version differences are pointed out where applicable. Screenshots are using 2010. In the spirit of working with tables via VBA, sometimes you may need to check the range of a table. This is fairly straight-forward in most cases, but sometimes it has [...]
This blog post will be based on working with tables via VBA. They present some unique issues, which has to do with how their structured in the object model. Good or bad, it's what we have. These are based on my trial and errors, so hopefully this will help somebody out there. That being [...]
