Select certain cells in a column

[egildone]

I need to copy certain cells in a column and past them into a word
document, but when I select them by using Ctrl+C I can select the
individual cells but when I try to paste them into word I get all the
cells between the first and last. I have tried using both paste and
paste special. What I mean is I select cell 3,6,9,12 using Ctrl+C it
selects the individual cells OK, but when I try to paste them into word
I get all the cells between 3 and 12. Is there a way to copy and paste
cells that are not contiguous and past them into a word document other
than one at a time?

Ed

 

[egildone]

I need to copy certain cells in a column and past them into a word
document, but when I select them by using Ctrl+C I can select the
individual cells but when I try to paste them into word I get all the
cells between the first and last. I have tried using both paste and
paste special. What I mean is I select cell 3,6,9,12 using Ctrl+C it
selects the individual cells OK, but when I try to paste them into word
I get all the cells between 3 and 12. Is there a way to copy and paste
cells that are not contiguous and past them into a word document other
than one at a time?

Ed

OK, I read the documentation and discovered I can select non contigous
cells and copy them but you are limited to 24 cells in one operation.

I answered my own question! It always help to read the documentation.

Ed

 

[Bill Kuunders]

Hi, I've waited a while to see whther there were better solutions.
One way would be to insert a help column do a series of 123 123 123 down the
column and then sort to show every third row.
You can then copy paste as per usual.
You could put some of this into a macro.