5,140
社区成员
发帖
与我相关
我的任务
分享
Sub Convt()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Activate
ws.Rows("1:1").Select
Selection.Copy
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Rows("1:1").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("A1").Select
Next
End Sub