Sub demo()
Application.ScreenUpdating = False
Path = ThisWorkbook.Path & "\"
file = Dir(Path & "*.xlsx")
While file <> ""
Set wb = Workbooks.Open(Path & file)
a = Range("a1:e" & [a1].End(4).Row)
For i = 1 To UBound(a)
v1 = IIf(i = 1, "B1", "C" & i - 1)
v2 = IIf(i = 1, "B1", "D" & i - 1)
a(i, 3) = "=2/(12+1)*B" & i & "+(1-2/(12+1))*" & v1
a(i, 4) = "=2/(26+1)*B" & i & "+(1-2/(26+1))*" & v2
a(i, 5) = "=C" & i & "-D" & i
Next
[a1].Resize(UBound(a), UBound(a, 2)) = a
wb.Close 1
file = Dir()
Wend
Application.ScreenUpdating = True
MsgBox "ok"
End Sub
祝順心,南無阿彌陀佛!