Michał
Pawłowski
Student, Szkoła
Główna Handlowa w
Warszawie
Temat: Makra i Visual Basic
Nie wiem, czy o to Ci chodzi bo nie do końca rozumiem Twoją prośbę.Sub ZmianaFormuly()
Dim i As Integer, j As Integer
Dim sFormula As String
Dim iNumerZnaku1 As Integer
Dim iNumerZnaku2 As Integer
Dim PierwszyNumer As Integer
For i = 4 To 300
sFormula = Cells(i, "S").Formula
iNumerZnaku1 = InStr(1, sFormula, "{", vbTextCompare)
iNumerZnaku2 = InStr(iNumerZnaku1, sFormula, ",", vbTextCompare)
PierwszyNumer = CInt(Mid(sFormula, iNumerZnaku1 + 1, iNumerZnaku2 - iNumerZnaku1 - 1))
For j = 0 To 4
sFormula = Mid(sFormula, 1, iNumerZnaku1) & PierwszyNumer + 5 + j & ","
iNumerZnaku1 = iNumerZnaku1 + 3
Next j
sFormula = Mid(sFormula, 1, iNumerZnaku1 - 1) & "},0)"
MsgBox sFormula
Cells(i, "S").Formula = sFormula
Next i
End Sub