Paste with noncontiguous selection?

[Justin Koh]

I am trying to paste a value into a non contiguous selection. The values only go into the last range shown. Is there another way to do this without overriding rewriting most of the paste code? Some flag I can set?

[Administrator]

So, you are trying to paste 1 value into many non-contiguous cells? If this is what you want, there is no property setting that will allow you to do this. You would have to code this yourself. You can handle the grid.ClipboardPaste event, and do the work there. Here is a rough sample that does something close to this. It copies a currentcell and places this on the clipboard with a special name, and then pasted in many cells in the paste. It is not clear you would need to use a special name format. Forum_CopyPaste_4723_6348.zip