Hello
Currently I use linest to generate a slope and constant.
The range represents two adjacent cells.
I would like to use the 1st degree coefficient and constant without the need for cells.
Something like
with fdeg being the 1st degree coefficient and cnst being the constant
Any ideas?
Thanks
Tom
Currently I use linest to generate a slope and constant.
The range represents two adjacent cells.
VBA Code:
Range(fdeg, cnst) = Application.LinEst(DriftDat, DriftIn)
Something like
VBA Code:
fdeg, cnst = Application.LinEst(DriftDat, DriftIn)
Any ideas?
Thanks
Tom