Hello Steve,

sorry for the typo, should refer to an adjacent cell, which is a product

matrix of error-terms. The reason for using Excel in this case is to be able

to show what I've done in detail to my thesis supervisor. And the ability

that, of lined up, little changes can be easily made and tracked down in

Excel. Thanks for the heads up on analytical software nonetheless.

These 16,000 regressions will stand apart from each other so will not

interfere in any kind. It just a simple routine, as described, that needs, in

due time, 16,000 repetitions. Something I'm not eager to do manually as one

can imagine.

My knowledge and skill in VBA has, by not using it for 3years, become a bit

rusty. So trying to implement your suggestion, as it is indeed what I was

looking for, I just want the solution found by the solver to be placed in

DU4, well it goes like following:

Sub test()

SolverReset

SolverOk SetCell:="$DV$4, MaxMinVal:=2, ValueOf:=1", ByChange:="$DU$4"

Dim retVal As Integer 'I believe one first has to specify something to be

integer followed by the direction on what the value of the integer is, in

this case solversolve

retVal = SolverSolve(UserFinish:=True) 'as I don't have a need to see the

dialog

MsgBox retVal

SolverFinish KeepFinal:=1

End Sub

Alas, I get the "Types do not match" I'm gonna try to find out why, though

as anybody has got any suggestion as to why, I'm open to that. Thank you so

far!

Jasper