Another site where the tasks considered suitable for programming in Excel and VBA are anything but “boring and repetitive” is Yakpol’s Spreadsheet Solutions For Structural Engineering:

“This web site contains a collection of engineering spreadsheets for structural analysis and design of concrete and steel structures. The programs have been developed by practicing professional engineers with emphasis on productivity, dependability, and clarity. To insure quality of the spreadsheets we have comprehensively compared analysis results to leading commercial software products and found them to be accurate.”

Those of you not into structural engineering may like to have a look at a few non-engineering applications, including:

Yakpol's Travelling Salesman Spreadsheet