Author Archive

I often find myself struggling to deal with data that has been rendered almost unusable by the data provider who has converted it to a cross tab format. Usually they think they are helping and have probably started with a nice flat list then spent ages formatting it so the data spreads out across...
Read more »

How to create a custom search folder in Microsoft Outlook 2007 that shows mail categorised in more than one specified category. A combined category search folder using the logical AND rather than the OR operator.
Read more »

I’m moving to a new job soon and wanted to take the opportunity to set up the new email system in line with GTD (Getting Things Done) methodology. Here’s my checklist for setting up the new system on Outlook 2007. Most tips and code are taken from Simon Guest over at Simon Says but I’ve amended...
Read more »

The blog post sounds a little Darwinian but I’m afraid it’s just a dull selection of VBA code that enables you to sort one array on the basis of values from another. A double sorting array. I’ve amended array sorting code from John Walkenbach and Anthony’s VBA Tutorials to create something I can understand....
Read more »

Here’s another VBA snippet post. I find it handy to have a store of regularly used macros on the blog so I can access them at any time, not that I need them that often of course. These particular snippets are useful routines for sorting arrays and can be called from other procedures. I’ve...
Read more »

I’ve been devouring word games over the last few weeks and found myself dreaming obsessively about 4-letter word combinations. Now it’s time to relax and to bring you my review of the Top 5 iPhone word games of all time. In my quest I’ve come across some awful games and some that just didn’t quite make...
Read more »

I thought I’d share my recommendations for what to fill your new iPhones and iPod touch machines with, starting with my take on the top 5 iPhone game applications available from the iTunes store. My games screen tends to change fairly regularly as I drop the duff purchases and curse the reviews that led...
Read more »

I’ve been a little disappointed with the latest update to the WordPress 2 iPhone app for blogging on the fly. Not that I blog on the fly that much but I do like to fiddle around with drafts while I’m at work (lunch time only of course) and it’s the draft functionality that appears...
Read more »

Here are 3 tools to enhance your twitter experience. Let me know if you use them already or have found better ways to achieve the same functionality. I currently let friendfeed handle the linking of flickr uploads to twitter but it’s not ideal. FF alerts the world to my first uploaded image in any...
Read more »

I regularly use simple macros to delete blank rows in my excel spreadsheets and there are loads of examples on internet forums. I’ve recently had to recreate these delete row macros to install on a new computer and thought it would be useful to keep them filed here on the blog. This first macro...
Read more »