About Us

RyanVM[_7_]

OK, this one has me extremely perplexed. I've got this line in a macr
I'm working on
Code
-------------------
Slope = Application.WorksheetFunction.Index(Application.Wo rksheetFunction.LinEst(Range("C" & MinRow & ":C" & MaxRow), Range("B" & MinRow & ":B" & MaxRow)), 1, 1
-------------------
Where Slope is a Double and MinRow & MaxRow are both Integers (assigne
values prior to this line).

This code worked perfectly in Excel 2003 on my home computer las
night, but when I took it back to work today and tried to run the macr
in Excel 97, I get the following error
Code
-------------------
Unable to get the LinEst property of the WorksheetFunction clas
-------------------
Why would this code work fine in Excel 2003 but not Excel 97

--
Message posted from http://www.ExcelForum.com

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007	ronny B	Charts and Charting in Excel	1	October 24th 08 10:08 PM
Copy and paste problem Excel 2003 to Word 2003	[email protected]	Excel Discussion (Misc queries)	2	August 28th 07 11:14 AM
Excel 97 chart opened in Excel 2003 - Source Data problem	DHunt	Charts and Charting in Excel	0	December 6th 04 08:05 PM
Problem with opening an Excel 2000 workbook in Excel 2003	Frank Krogh[_2_]	Excel Programming	0	June 3rd 04 11:31 AM
Problem with opening an Excel 2000 workbook in Excel 2003	Frank Krogh	Excel Programming	0	June 3rd 04 07:41 AM

Menu

About Us