Macro and Calculation.

[zerowalker]

I am not that familiar with Excel, but i want to make a Macro, and perhaps a calculation of the results i will be getting in a function (if possible).

So here is a file:

Now the function i want to do is:
"X" = From Row 2, till the the last row before it goes blank (don't know if this is possible, currently i have to scroll and write manually).

LINEST(C2:C"X",A2:A"X",TRUE,FALSE)
Give me the 2 answers, donīt know how it can be give, if i can get it written or something would be nice.


LINEST(H2:H"X",G2:G"X",TRUE,FALSE),1)


If this is possible, it would save alot of time. And then i would also try to give the calculation of the results a try, though i doubt it's possible, but then again, i am not familiar with Excel.