Thanks Gary's , I have given this ago but say within thoes selected cells
that A2 is shaded gray that shading will not come accross for me. How do I
get the shanding to transfer accross as well as the data

"Gary''s Student" wrote:

Say the area is from A1 thru B2.

Select A1 thru B2 on the first sheet and:

Edit Copy

then select cell A1 only on the second sheet and:

Edit Paste Special Formats.
--
Gary''s Student - gsnu200808


"DJ" wrote:

How can I copy a range of cells (some of which are filled with gray) from one
worksheet to another worksheet without deleting any data that may be in the
same range on the second sheet.