Try Ediypaste specialvalue
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"N.F" wrote:

I have Row 31 (the entire row) in my worksheet in color and would like it to
remain as is. However Ill be cutting and pasting from other cells into cells
that lie in this row. When I cut and paste into the colored row the cell in
Row 31 changes to white. How can I cut and paste into my colored row
retaining the color by simply cutting the value and not the actual color???