我有28列,但是每7列之后我要插入一个空列。您能帮我创建那个宏吗?
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = "LP"
For i = 2 To 22
Sheets(i).Activate
Sheets(i).Cells(5, 2).Select
Sheets(i).Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Sheets("Linearity Plot").Activate
Sheets("Linearity Plot").Cells(i - 1, 1).Select
ActiveSheet.Paste
Next i
ActiveSheet.Range(Cells(1, 1), Cells(21, 121)).Select
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = "Transpose"
Sheets("Transpose").Activate
Worksheets("LP").Range("A1:DQ21").Copy
Worksheets("Transpose").Range("A2").PasteSpecial Transpose:=True
试试这个代码:
Sub insertColumns()
Dim lastCol As Integer
lastCol = 28
Dim i As Integer
i = 0
Dim nbColAdded As Integer
nbColAdded = 0
While i < lastCol + nbColAdded
i = i + 8
nbColAdded = nbColAdded + 1
Cells(1, i).EntireColumn.Insert
Wend
End Sub
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句