I figured that might work. I thought there might be a way without setting a
range. but i'll just use a generic date.
thanks
dominique
"JulieD" wrote in message
...
Hi
use Data / Validation
to do this:
select column C
choose Data / Validation
on the settings tab under allow - choose Date
set a range
click the Error Alert tab
write a personalised error message
click OK
test it out
for more details on Data / Validation (and other great stuff) check out
Debra Dalgleish's site at
www.contextures.com/tiptech.html
Cheers
JulieD
"Dominique Feteau" wrote in message
...
Basically what I need is some code that will have a message error saying
something like "Invalid Date, Please retry" whenever anything other than
a date is entered in cells c2:c65536.
i know there is an easy way of doing this, but i've coming up blank. can
anyone help me?
thanks
dominique