LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linest function for curve Baffeled Excel Discussion (Misc queries) 2 February 4th 09 01:18 PM
LINEST Function mcduffcpa Excel Discussion (Misc queries) 5 January 5th 09 07:26 PM
Linest function Barna Excel Worksheet Functions 1 February 16th 07 11:43 PM
linest function Mitch Excel Programming 2 December 5th 05 10:43 PM
LinEst function Darius Blaszijk Excel Programming 3 June 10th 04 03:12 AM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"