excel paste value to word

不太明白你的問題, Word 預設格式先左至右, 再上而下, 但你希望先上而下, 再左至右嗎?

2011-03-30 23:46:05 補充：
呢個有啲難度, 就算要做應該都要經 VBA, 而且比較轉折, 因為牽涉到 copy range 同 clip box…

我諗要先喺 Excel 度將橫列轉成直行, 跟住先至 copy to clip box, 咁喺 Word 度 paste 出嚟嘅就應該會係先直後橫。

2011-03-31 18:29:28 補充：
哈哈~ 正研究 data collection 嘅細節, 就俾我發現咗個相關功能!

正如我意見3 所講, 你 copy 咗想要嘅 cells 之後, 喺 Excel 空白嘅位置用 paste special > transpose, 咁你就可以得出你想要嘅 list pattern… 喺 Excel 度, 之後點做唔駛教啦~~

2011-03-31 20:41:26 補充：
你指數字靠 table 右邊而你想啲數字同文字一樣靠左???

2011-04-02 17:05:20 補充：
Sub TextTranspose()
If IsArray(Application.Selection) = True Then
Selection.Copy
Workbooks.Add
Sheets(1).Cells(1, 1).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Application.CutCopyMode = False

2011-04-02 17:05:58 補充：
Selection.Copy
Sheets(2).Cells(1, 1).PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False
Sheets(2).Activate
Selection.Formula = "=CONCATENATE(Sheet1!A1)"
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlank:=False

2011-04-02 17:06:17 補充：
Application.CutCopyMode = False
Else
Response = MsgBox("That is/are not the preferred array.", 0, "Text Transpose")
End If
End Sub

exactly!
i want something like this
1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18

2011-03-31 11:49:07 補充：
oh, i understand what you mean, but i tried it before, seems fail, anyway, thank you very much!