Posts

Un-embedding an Excel object from Powerpoint

Sometimes you get a Powerpoint deck featuring graphs and tables…

Useful VBA pages for data sheet manipulation

http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx http://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx

VBA code to test if a cell is all upper case

This tests to see if a cell is ALL UPPER CASE. If so, it replaces…