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

I've downloaded sets of code  examples and even BOUGHT CD's of them.
But in the end, it has been quicker to use the internet and groups
like this one.

The sets of code and the CD's usually are not indexed well enough to
easily find what I need. Plus, If you're wanting something "like"
what the example has, but slightly different. You can't get help
from a CD!

90% of the help I needed I've found in Excel's VBA Help. However,
I've been lucky enough to write code in 6-8 different languages, so
I kind-of know what I'm looking for and what different languages
call it. (There's a whole series of string functions in "C" that are
similar to the InStr function in VBA)

So, my suggestion? Keep coming to us!
You'll find all KINDS of things you never knew you wanted to know!

I troll the microsoft newsgroups, they are great resources. And here
are some great code  repositories.

http://www.vba-programmer.com/index.htm
http://lacher.com/toc.htm
http://www.cpearson.com/excel/mainpage.aspx
http://www.mvps.org/dmcritchie/excel/excel.htm
http://www.contextures.com/tiptech.html