Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running LinEst() from VBA
I have answered this often in the past. Here is a link to those answers:
http://tinyurl.com/yrmeeq -- Regards, Tom Ogilvy "Mitch" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINESt | Excel Discussion (Misc queries) | |||
Linest | Excel Worksheet Functions | |||
LINEST bug | Excel Worksheet Functions | |||
LINEST | Excel Discussion (Misc queries) | |||
Linest - Why did they do that? | Excel Discussion (Misc queries) |