Macro and Calculation.

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.

Post an excel file, without confidentional information.

Please also add the desired (expected) result.

What do you mean, Confidental information??

Here it is: http://www.sendspace.com/file/268ir5

And for the result, on this file i am expected to get:


=LINEST(C2:C46822,A2:A46822) = 33.4736187211877 , 67.8567627719...

=LINEST(H2:H3135,G2:G3135) = 0.0026042210295967 , 12.80325929


rcm: VBA?
Do you mean Visual Basic Scripting?

I am as said, not familiar, care to point me in the right direction?

EDIT:

Okay found the VBA thing, but i seen to get an error when i try this:

Cells(1, 1) = Application.WorksheetFunction.linest(Range("B2", Range("B2").End(xlup)), Range("c2", Range("c2").End(xlUp)), True, False)

It says "invalid outside procedure", and sadly, that doesn't tell me anything.

EDIT 2:

OKay think it was becuse i ran the script on the script manager, instead of in Excel, not i get another error though, but atleast it seems to run.

Sorry i'm not familiar with formulat linest.

Maybe another one will step in to give an solution.

Name Manager > New, Name: x, Refers to: ='test test for sync'!$A$2:INDEX('test test for sync'!$A:$A, MATCH(9E+307, 'test test for sync'!$A:$A))

Name Manager > New, Name: y, Refers to: ='test test for sync'!$C$2:INDEX('test test for sync'!$C:$C, MATCH(9E+307, 'test test for sync'!$C:$C))

Select two cells and array-enter =LINEST(y,x)

You'll have to save the workbook as an xlsx to preserve the names.

I did this on the csv file you posted without difficulty; there were no blanks.

It can be done with blanks, but it's very messy. I suggest you compact your data to eliminate them.

Okay i have been able to get a function that does mostly what i intended.

What function?

Second, i can't use the macro/vba on what i want, ...

Why not?

If you would POST your code, I'd make a suggestion.

Please Login or Register  to view this content.

Awesome!

Now the thing left is.

I want to have 2 check boxes, and i want one to be checked as default, and if i check the other, a value will differ.

Please Login or Register  to view this content.

bit is that value.

I can change it with a checkbox easily, But the problem is, the data doesn't refresh.
I donīt know how to make it refresh when the value changes.


EDIT:

Okay i am totally lost on this, i search and search but i donīt seem to be able to do what i want to do.

I simply want to have 2 checkboxes,(OptionButton), and if i check one, a variable will change, and if i check the other it will change to something else.
A = 2 if OptionButton1 is checked, for example.

But the problem is, even if i set something like that, i donīt know how to make it update the information, for example

Texboxt1 = U *553 / A

So if i change the checkbox, The value of Textbox1 will change.

Hopefully you understand, i am not that good at explaining, but itīs fairly easy what i am trying to do.

EDIT 2:

Just because of that, i actually solved it;P