| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste contents, but keep formula of destination | Excel Discussion (Misc queries) | |||
| Paste data to cell and keep destination font and size | New Users to Excel | |||
| Loop Statement through If Not IsEmpty Then Paste into Destination | Excel Discussion (Misc queries) | |||
| Require a cell to be nonblank if another cell is nonblank | Excel Discussion (Misc queries) | |||
| copy paste values only using destination:= | Excel Programming | |||
![edwardpestian[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
