Copy to clipboard

Good morning excellentexcel

Originally Posted by excellentexcel

after a way to copy a group of cells to clipboard (a21 to c24) and leave it there until i need it
is this possible?

The clipboard is a Windows object, not an Excel object so referencing it is not as easy as you might think.

Chip Pearson has an excellent article on the issue here with code examples and workbooks for download.

HTH

DominicB

Hi excellentexcel

Originally Posted by excellentexcel

Thanks dominic
not quite sure how i can adapt that though to suit my needs?i just want to press the button and it will store them cells on my clipboard.
Tried doing it using macro recorder to no avail

The macro recorder won't work as it's a Windows object.
Have a look at the attached example. type something in A1, click the button and then manually paste it somewhere else.

HTH

DominicB

Hi excellentexcel

OK. The clipboard can only hold one item at a time - it can be manipulated into copying multiples into there, but you are going to have to manually keep track of the size of the array (R x C) and the items in there, and (possibly) a delimiter character. Do you really have to use the clipboard?

Take a look at the code below - it's a bit rough at the moment, but it's a starting point. Highlight a selection (say 10 rows x 3 columns) and run the copy1 macro.

Now highlight a blank range (different shape - same number of cells, say 2 rows x 15 columns) and run the macro paste1.

As I say, it needs refining, perhaps you would like it to keep tha shape of the selection, so you only need to select 1 cell and paste from there - but it's a starting point. Would this be of any use to you?

Please Login or Register  to view this content.

HTH

DominicB

try a freware clipboard extender like this one
http://www.clipmagic.com/