The Internet is that repository, isn't it? I usually just use Google
to search for what I want, then customize the code  and put it into my
standard add-in for any future use.

For example, I just searched Google for:

vba max  value address

Found quite a few examples of straight-forward formulas, not even
requiring VBA. However, this web page had both:

http://support.microsoft.com/kb/139574