Rating: 

The 2 that have worked so far for me are Hack #42 (dynamic named ranges) and #32 (cell formatting).

I understand that the cell formatting one is probably buried somewhere in the so-called documentation from MS but I never found it. And dynamic named ranges have so many different uses, I can't begin to list them all - list management, more efficiently run macros using pre-determined ranges etc.

There's about another dozen hacks which are now at the back of my head and the next time I update more workbooks, they will come into play.