Thread: function LINEST
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
God Itself God Itself is offline
external usenet poster
 
Posts: 29
Default 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?