Copy To Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sheeba - 26 Jan 2006 08:10 GMT

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

Reply to this Message

Ed - 26 Jan 2006 13:39 GMT

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

> Hello!
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Ed - 26 Jan 2006 15:10 GMT

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

> 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
[quoted text clipped - 14 lines]
> >
> > Thanks

Reply to this Message