Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LinEst with operator
My VBA code for LinEst won't work with any operator.
I hope you will have the right code for me. Thanks Sub LinEst_Test() Dim reg1 As Double Range("A1") = 4 ' given Range("D5") = 8 ' given Range("D6") = 10 ' given Range("D7") = 12 ' given Range("D8") = 16 ' given ' Cells(3, Cells(1, 1)) = Application.LinEst(Range(Cells(5, Cells(1, 1)), Cells(8, Cells(1, 1)))) * 2 ' won't work Cells(3, Cells(1, 1)) = Application.LinEst(Range(Cells(5, Cells(1, 1)), Cells(8, Cells(1, 1)))) reg1 = Cells(3, Cells(1, 1)).Value Cells(3, Cells(1, 1)) = reg1 * 2 End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions | |||
Linest: problems using broken reference data | Excel Worksheet Functions | |||
linest won't accept multiple reference ranges | Excel Worksheet Functions | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions |