Try one of John Walkenbach's books http://www.j-walk.com/ss/. I use his book Excel 2000 Power Programming With VBA constantly. If you are new to Excel/VBA, you will find his books extremely useful anyway.
My experience is that VBA codes can be sped up a lot. I would also suggest you use...