Hi

Try using CopyPaste Special
You then have the choice of pasting Values or Formulae, and the format
of the receiving cell(s) will not be altered.

--
Regards

Roger Govier


"Rocco_Boy" wrote in message
...
I have a spread sheet with different colored columns. I often drag
and drop data from one column to another but the color in the cells
gets dragged along leaving the cells white with no fill. Can this be
avoided. I've tried conditionally formatting the column colors but it
doesn't fix this. Thanks.