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.