what do you want to happen when there is an error?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"michaelberrier" wrote in message
oups.com...
Bob: That error handling stops the error, but the code still doesn't
run if there isn't a date in that cell, and I need that capability.

Dave: I need for the user to be able to enter something besides a date
in that box in it's applicable.

Thanks to both of you.