I just put up a first little version of a VBA library, which is a collection of function for doing stuff in Excel VBA. There are a few functions for ranges, strings and VBA modules. Currently (2007-12) I am not doing any larger VBA project. Once I work on something that has more than a few lines of code however, this library will certainly grow.
You can find the whole thing here.