Hello
I have this vba functions codes :
I have a problem with it
that when the calculation is done , and close the Excel File, and open it again, I see that the function start from the zero , and I found that the cells is not like the final result (before close the file)
is that any way to storing the results even close the file and open it again ?
I have this vba functions codes :
Rich (BB code):
Option Explicit
Public Function puissance2(Taux_CPrincpal As Double) As Double
On Error Resume Next
Dim x As Double
puissance2 = Taux_CPrincpal
For x = 2 To 90
puissance2 = (puissance2 + Application.Power(Taux_CPrincpal, x))
Next x
End Function
Public Function deversement(Charge_Centre_Principal, Centre1 As String, Vlrange1 As Range, Vlcolone As Double, TauxCP As Double) As Double
On Error Resume Next
deversement = (-Charge_Centre_Principal * Application.WorksheetFunction.VLookup(Centre1, Vlrange1, Vlcolone, 0)) * (1 - puissance2(TauxCP))
End Function
that when the calculation is done , and close the Excel File, and open it again, I see that the function start from the zero , and I found that the cells is not like the final result (before close the file)
is that any way to storing the results even close the file and open it again ?