What do you propose to do with observations C7:C18 that have no explanatory
variables?

Jerry

" wrote:

The Excel function Linest does not return a value if your independant
and dependant variable count :i.e. Linest(C3:C18,D3:D6) do not match.
Is there a way to code this in VBA?