|
項目固定//就一律用定義名稱,
不管怎移(只要不刪除該列). 都劍在人在//
Sub TEST_A1()
Application.ScreenUpdating = False
Application.Calculation = xlManual
For i = 1 To 12
With Sheets(i & "月")
.Select
Range("$B:$B").Name = "'" & ActiveSheet.Name & "'!姓名"
Range("$O:$O").Name = "'" & ActiveSheet.Name & "'!应发工资"
Range("$R:$R").Name = "'" & ActiveSheet.Name & "'!专项扣除"
Range("$T:$T").Name = "'" & ActiveSheet.Name & "'!个人所得税"
With Range("$U:$W")
.Replace "B:B", "姓名", Lookat:=xlPart
.Replace "o:o", "应发工资"
.Replace "s:s", "专项扣除"
.Replace "t:t", "个人所得税"
End With
End With
Next i
Application.Calculation = xlAutomatic
End Sub
|
|