I'm using pastespecial to copy values from one range to another. I've tried setting the skipblanks to true to prevent original blank cells from overwriting data in destination cells, but I'd rather have it check to see if the destination cells have data first, and the complete the pastespecial command. Any ideas?

Thanks.

EP