As a recognition granted by Microsoft, Microsoft Most Valuable Professionals, or MVPs, are tech experts who passionately share their knowledge with the community. They possess a profound understanding of Microsoft products and services and can bring together diverse platforms, solutions, and products to solve real-life problems. MVPs constitute a global community of over 4,000 [...]
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 [...]