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? |
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? |
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? |
All times are GMT +1. The time now is 05:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com