Hello!

How can I copy Cells A1, C1, E1 to word as a table wit only one column?

i find it easy to copy as three column but in word there is no option
to Transpose while pasting.

any help?

Thanks

If you are looking for a VBA solution, one way would be to put each cell
value in a separate string (or read them into an array), then create your
table in Word and populate each cell from your strings (or array). From
within Word, you could add two rows, make Cell(2,1)=Cell(1,2) and
Cell(3,1)=Cell(1,3), then delete the last two columns.

Ed

"sheeba" wrote in message
oups.com...
Hello!

How can I copy Cells A1, C1, E1 to word as a table wit only one column?

i find it easy to copy as three column but in word there is no option
to Transpose while pasting.

any help?

Thanks

Probably a better way would be to coy into an empty portion of your workbook
using Transpose, then copy that to paste into Word.

"Ed" wrote in message
...
If you are looking for a VBA solution, one way would be to put each cell
value in a separate string (or read them into an array), then create your
table in Word and populate each cell from your strings (or array). From
within Word, you could add two rows, make Cell(2,1)=Cell(1,2) and
Cell(3,1)=Cell(1,3), then delete the last two columns.

Ed

"sheeba" wrote in message
oups.com...
Hello!

How can I copy Cells A1, C1, E1 to word as a table wit only one column?

i find it easy to copy as three column but in word there is no option
to Transpose while pasting.

any help?

Thanks