how can i make an excel calculation engine?
Hi
Short demo:
Sub test()
Dim i As Long
Application.Calculation = xlCalculationManual
Range("B1").Formula = "=A1*2"
Range("B2").Formula = "=A1*3"
Range("B3").Formula = "=A1*4"
For i = 1 To 5
Range("A1").Value = i
Range("B2:B3").Calculate
MsgBox i
Next
End Sub
HTH. Best wishes Harald
"Monique" skrev i melding
...
i'm trying to figure out a way to put all calculations taking place in the
workbook in one location. It will stop the redundancy of calculations
taking
place on multiple sheets. Any advice or help will be greatly appreciated.
Thanks
|