Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function LINEST
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
function LINEST
If you are GOD then you already know the answer.
"God Itself" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
function LINEST
hi
even god may have problems with vba ;) but being serious. function without Columns works ok (but then i may only add/remove rows from original range) problem is when i want to add/remove columns fromoriginal range... regards Użytkownik "measekite Da Monkey" napisał w wiadomo¶ci ... If you are GOD then you already know the answer. "God Itself" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |