Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
i have function: Function RegLinMod(rng1 As Range, rng2 As Range, a As Long, b As Long, c As Long, d As Long) Application.Volatile Set rng1 = rng1.Parent.Range(rng1.Rows(1 + a), rng1.Rows(rng1.Rows.Count - b)) Set rng2 = rng2.Parent.Range(rng2(Rows(1 + a), Columns(1 + c)), rng2(Rows(rng2.Rows.Count - b), Columns(rng2.Columns.Count - d))) RegLinMod = Application.WorksheetFunction.LinEst(rng1, rng2, 0, 1) End Function why columns property cause circular reference? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linest function for curve | Excel Discussion (Misc queries) | |||
LINEST Function | Excel Discussion (Misc queries) | |||
Linest function | Excel Worksheet Functions | |||
linest function | Excel Programming | |||
LinEst function | Excel Programming |