Cell B1 of activesheet contains a valid date in excel date format.

--
Jacob (MVP - Excel)


"Dan Wood" wrote:

There is no error this time but i cannot find them in the calendar. Is it
anything to do with formatiing the date cell?
Sorry to be a pain!