This one is driving me crazy.
I have a workbook that runs vba to start a solver routine on a sheet "Model" then
transfers the results of the solver to column on a results sheet. The solver resets and then using lookup routine gets data
form a readings sheet paste into the solver sheet and re runs solver.
This loop continues for continues for approx
70 cycles then ends.
All works fine but the screen constantly switching between the sheets looks very amateurish
and annoys me!
I did try hiding the sheets at the start of the routine but this stopped the macro on an error.
This is the main code for this section.
For nbline = 4 To 75
dateprod = Cells(nbline, 1)
Cells(3, 3) = dateprod
stwobbe = Cells(36, 5)
Cells(nbline, 4) = Application.WorksheetFunction.Max(0, stwobbe)
solverok setcell:=Cells(36, 5), maxminval:=3, valueof:=Wobbelimit, bychange:=Cells(42, 16)
volume = Cells(42, 16)
massco2 = Cells(53, 6)
Cells(nbline, 3) = Application.WorksheetFunction.Max(0, volume)
Cells(nbline, 5) = Application.WorksheetFunction.Max(0, massco2)
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Anyone have any ideas.?
Or should I not be so fussy?