Yes, because my code takes the underlying value from the cells, not what is displayed in them (meaning formats are ignored). Will those two date cells always be the same cells? If so, what are their addresses (I see if I can correct the data while it is being compiled). If I can't, I'll have to rewrite the code.Hi Rick, it all worked except the formatting of two my my cells was changed when pasted onto the Notepad file. The cells have dates in the format of yyyymmdd in Excel, but in Notepad they changed to m/d/yyyy. Any idea why?