View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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