try

Paste Special Under Paste in the dialog box, tick Value

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"Graham" wrote:

I want to fill a cell with a colour but still be able to copy to that cell
without the fill changing. Is this possible.

Thank You