Thats correct: some contain data and some are blank and this method works for
those cells, however some cells are also shaded gray. I can't get those cells
to copies accross and be shaded gray on the second sheet.
Can you help

"ShaneDevenshire" wrote:

Hi,

I think you mean how can you copy a range that contains blank cells and not
delete the target range where the blank cells get pasted"

If that is your question then,
1. Select your range and choose Copy
2. Move to the other range and choose Edit, Paste Special, and check Skip
Blanks.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"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.