Use Paste Special | Values or Paste Special | Formulas, depending on the content of the cell, rather than just Paste.


Regards, TMS