Anything and everything that takes an inordinate amount of work to do by hand?
Look through this for ideas:
Best Macro List
-Chris
For more information, see the wiki Searching the Forum for Answers section.