I didn't write any of this code originally. Someday, I would love to have a chance to stare it down and remove everything that isn't needed. If I didn't hate working on Excel automation, that is.
Of course, this being Excel automation code, the trick is figuring out what is needed and what isn't...