If you can think of other things to check, you may want to add them to your
code, too.

The stuff that is only a remote possibility will happen the hour before your
vacation starts!

Casey wrote:

Dave,
Thank you very much for the help and the tutorial. I really appreciate
the time. I will keep both checks even though the "if rng8 is nothing
then" is, as you suspected, a very remote possibility. Thanks again.

--
Casey

------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=551205

--

Dave Peterson