Geez--this is my second post of the morning. Sorry about not thinking my =

queries through all the way!

Anyway, I have the following macro which deposits the date and time into =
a=20
cell:

Sub DateAndTime()
With ActiveCell
.Value =3D Now
.NumberFormat =3D "mm/dd/yy h:mm AM/PM"
End With
End Sub

Unfortunately, the stamp deposited into the cell seems not to be =
recognized=20
by Data Validation, which is set up to flash a warning box if the time =
entered=20
is after 5:00 PM. If I enter the identical info that the macro generates =

manually and hit "Enter," THEN Validation pops the warning box up.

What am I doing wrong? Can I rewrite the macro so that it essentially =
hits=20
"Enter" at the end so that validation will work?

Thanks!