Posts

Un-embedding an Excel object from Powerpoint
Sometimes you get a Powerpoint deck featuring graphs and tables…

Excel “Short” to “Long” data reformatter
0 Comments
/
I'm not sure where I got the following file (a quick Google didn't…

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…