PMFJI, don't you ever get those undeclared variable errors when you run
the
initial code?

I guess not. Just kidding, of course I do but whenever I write a procedure
I test it immediately so, with Option Explicit set, undeclared variables and
other problems pop up immediately. No harm in doing a compile except it
bloats file size, if that's an issue. I know that "compiling" is supposed
to speed up code running initially since Excel doesn't have to compile it at
run-time, but I've never experienced this time savings/penalty as a
practical matter. Just my opinion of course.

--
Jim Rech
Excel MVP