Don't be too hard on yourself. On this site VBA is the first tool most people reach for.
It's unfortunate because there is so much that can be done without it and all its attendant issues. If you really want to push the envelope with XL check out the the XL newsgroups. Or, visit the sites of various MS MVPs. A non-exhaustive list: Bullen, Walkenbach, Pope, Pearson, Peltier, and myself.