View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edwardpestian[_4_] edwardpestian[_4_] is offline
external usenet poster
 
Posts: 1
Default paste only if destination cell nonblank


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


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=537330