原代码是在"3值"右边插入4列,而现在想改为"3值"左边边插入3列,是吗?
如果是,改为蓝色这句即可
Sub InsertCol()
Dim Ar, i%
Ar = Sheets("表格1").Range("a1", Sheets("表格1").Cells(1, Columns.Count).End(xlToLeft))
Application.ScreenUpdating = False
For i = UBound(Ar, 2) To 1 Step -1
If Ar(1, i) = "3值" Then
Debug.Print Range(Cells(1, i - 2), Cells(1, i)).Address(0, 0)
Range(Cells(1, i - 2), Cells(1, i)).EntireColumn.Insert Shift:=xlToRight
End If
Next
Application.ScreenUpdating = True
End Sub