加一句哦
Sub hjs() Application.ScreenUpdating = False Sheets("表1").Visible = True Sheets("表2").Visible = True Sheets("表2").Select Range("A2:F2").Select Selection.Copy Sheets("表1").Select Range("a1").Select '就是这里 Selection.PasteSpecial Paste:=xlAllExceptBorders, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=True End Sub
或
Sub hjs1() Application.ScreenUpdating = False Sheets("表2").Range("A2:F2").Copy Sheets("表1").Range("a1").PasteSpecial Paste:=xlAllExceptBorders, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=True End Sub |