Thanks for the response. Actually, Excel crashed on me a while ago so I
can't try your suggestion now. I'll try tomorrow and let you know. Thanks!
-----Original Message-----
Hi Michael,

Instead of
If Now Mod 1 12 / 24 Then ' 12/24 = 12:00 PM
use:
If Hour(Now) = 12 Then ' past noon

Regards,

Daniel M.


.