Code

>Tag:Code

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 workbook (or current application calculation [...]

March 16th, 2013|Tags: , , , , |7 Comments

Delete styles in MS Excel

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 bloated with [...]

January 14th, 2013|Tags: , , , , |9 Comments

Get Table Addresses

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 [...]

January 14th, 2013|Tags: , , , , |6 Comments