I give up. Without your telling us your parameters I don't know what
you're trying to do. You can get the same result, and a lot easier, by
simply copying cell A-1 and pasting it into cell A-2. I did have to
construct a new format to get mmm'yy instead of mmm-yy but once
established it carries into every pasted or copied cell (was that your
problem?). Unlike your solution if A-1 changes to a different date, A-2
will not change (but you didn't say your criteria in this regard).
If you want the date to change in A2 when it changes in A1 simply put
the formul =A1 in cell A-2. You don't say what you are copying in
order to paste special values. If it is A-1 your copying you get a
number with paste special values. If it is A-2 you'r copying you might
as well have put =A2 in the new cell. ed