Sub 修改()
Dim X As Integer
For X = 2 To 31
Sheets(x).select
Range("D4:D38").FormulaR1C1 = "=Sheets(x-1)!RC[11]+RC[12]"
Range("H4:H38").FormulaR1C1 = "=RC[-1]+RC[9]"
Next
End Sub
Sub 修改()
Dim x As Integer
Dim n As String
For x = 2 To 31
With Sheets(x)
n = Sheets(x - 1).Name
.Range("D4:D38").FormulaR1C1 = "=" & n & "!RC[11]+RC[12]"
.Range("H4:H38").FormulaR1C1 = "=RC[-1]+RC[9]"
End With
Next
End Sub
Sub 修改()
Dim x As Integer
Dim n As String
For x = 2 To 31
With Sheets(x)
n = Sheets(x - 1).Name
.Range("D4:D38").FormulaR1C1 = "=" & n & "!RC[11]+RC[12]"
.Range("H4:H38").FormulaR1C1 = "=RC[-1]+RC[9]"
End With
Next
End Sub