不难,录一个宏即可,等下我发代码,如果你有代码,请发上来 宏代码(没有调试合并单元格情况,只能简单单列(行)转置):Dim MyClip As New CClipboardSub Macro1()
Dim a() As String
Dim TempStr As String
TempStr = MyClip.GetText()
a() = Split(TempStr, Chr(13))
a() = Split(a(0), Chr(9))
Dim TempCol As Integer
Dim TempRow As Intege...
|