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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste only if destination cell nonblank
if isempty(activeCell) then
activecell.pastespecial xlValues end if -- Regards, Tom Ogilvy "edwardpestian" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste only if destination cell nonblank
Once I've implemented all that, I still need the data to be copied based on two criteria: Shift: which is a list box containing "Day" "Swing" & "Grave" And Date, which is a reference to the date in a specific cell. These two factors need to be found in a range of cells, and then the values pasted. Basically, I need to have and offset function to find the cells where the data needs to be pasted. Below is a formula that I'm using to find the info once it's pasted, so I need to somehow utilize this to paste the data. I hope this makes sence. =IF(Date=0,"",OFFSET($C$6:$C$109,,MATCH(Date,$D$3: $CV$3,0))) Thanks again.. -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=537330 |
Reply |
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 |