Posted to microsoft.public.excel.programming

Mitch

external usenet poster

Posts: 88

Running LinEst() from VBA

I am trying to run the linest() function from a VBA procedure, but keep
getting the
"Unable to set the FormulaArray property of the Range class" error message.
I am using the following VBA code within the procedure.
' select range for primary cubic values
ActiveSheet.Range("E25:H29").Select

' run linest() function
Selection.FormulaArray = _
"=LINEST(.Range(Y_rngStr)& "", "" & .Range(X_rngStr)& ""^{1,2,3},,TRUE)"""
Any suggestions?

Reply With Quote

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

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	[email protected]	Excel Discussion (Misc queries)	1	December 8th 08 03:54 PM
Linest	baron2ci	Excel Worksheet Functions	0	April 8th 08 12:46 AM
LINEST bug	Mark Schreiber	Excel Worksheet Functions	2	April 27th 07 07:26 PM
LINEST	pjk@boro	Excel Discussion (Misc queries)	2	February 20th 06 09:56 AM
Linest - Why did they do that?	cseeton	Excel Discussion (Misc queries)	2	March 11th 05 12:45 PM

All times are GMT +1. The time now is 08:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us